2. Right click on highlight and paste the data in a new column
3. Click on Paste…
4. Click on Data Tools
5. Click on Remove Duplicates
6. Click on OK
7. Click on highlight
8. Click on Sort Descending
9. Type GENERAL SERVICE TYPE as your column label
10. Type GENERAL SERVICE TYPE again as your column header
11. Type DEDICATED for the two service types that are dedicated and ON DEMAND for the remaining service types.
12. Click on highlight
13. Use the fill handle to propagate the remaining cells with "ON DEMAND".
14. click to highlight the cell where you will enter your VLOOKUP function.
15. Type =VLOOKUP(
16. Type =VLOOKUP(C2, or click in the cell you will use as your lookup value.
17. Click and drag to select your table array. Add a comma. Enter the column number where you want the function to "look". Add a comma, then type "false)" and hit enter.
18. The function returned the value you requested. Now double click on the Fill Handle to pull your formula down the rest of the column.
