String vs. Table Look Up
 

Here is my table. Not sure how to complete a table look up. I am running
Excel 2002. 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


"Carlo" wrote:

I have been banging my head against the table trying to ADD to this string,
however I have had no luck. Can someone help me, if all possible please.

CURRENT STRING

=IF(OR(B7="Departure",B7="Arrival"),IF(OR(E7="Seda n",E7="Van"),20,IF(E7="Limo",22,IF(OR(E7="Bus",E7= "Suv"),30,"Undefined"))),IF(OR(B7="Wedding",B7="So cial"),IF(E7="Limo",10*N7,IF(E7="Suv",12*N7,"Undef ined")),"Undefined"))

Additional Info to add:
If B7 = Bar Run or Night Out and if using a Sedan = $50, if a Limo = $60 if
using a Suv or Bus = $70

Additional Info to add:
If B7 = Prom and if using a Limo = $40, if using Suv or Bus = $70