Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding additional string vs. look up table
Hello Greg and Dougal
Thank you both for helping. I will test your string, however I cannot remember how a look up table works, would either of you two gentlemen be able to help me. Here is my table information. The sheet name is PayShedule: VAN BUS FROM TO CAR LIMO SUV Airport Hamilton Toronto $20 $22 $30 Airport Brantford Toronto $30 $30 $40 Bar Run Hamilton Toronto $50 $60 $70 Bar Run Hamilton N Falls $50 $60 $70 Add'l Pick Up Drop Off $2 $3 $5 Hourly Social Social $10 $10 $12 Hourly Wedding Wedding $10 $10 $12 Prom Hamilton Burlington $30 $40 $50 Prom Hamilton Other $40 $40 $70 Airport Hamilton Hamilton $12 $12 $15 Airport Grimsby Toronto $25 $25 $30 Airport Caledonia Toronto $30 $30 $40 Airport Cayuga Toronto $30 $30 $40 Airport Jarvis Toronto $30 $30 $40 Airport Hagersville Toronto $30 $30 $40 Airport Hamilton Buffalo $35 $35 $45 Airport Grimsby Buffalo $35 $35 $45 Airport Caledonia Buffalo $40 $40 $50 Airport Cayuga Buffalo $40 $40 $50 Airport Jarvis Buffalo $40 $40 $50 Airport Hagersville Buffalo $40 $40 $50 Airport Brantford Buffalo $40 $40 $50 Bar Run Hamilton Hamilton $30 $40 $50 Bar Run Hamilton Mississ $30 $50 $50 Bar Run Hamilton Oakville $30 $50 $50 Bar Run Brantford Hamilton $40 $50 $50 Bar Run Brantford Toronto $60 $70 $80 Bar Run Brantford N Falls $60 $70 $80 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Having problems to add additional info to this string.... | Excel Worksheet Functions | |||
Forgot to save a workbook after adding additional info | Excel Discussion (Misc queries) | |||
an additional pivot table | Excel Discussion (Misc queries) | |||
Charts - Adding additional data problem. | Excel Discussion (Misc queries) | |||
Adding additional data to a pivot chart | Charts and Charting in Excel |