View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Carlo Carlo is offline
external usenet poster
 
Posts: 179
Default 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