two dimension look up table
 

Can anyone tell me how to lookup a value with two variable options. i am
specifically looking at a type of car engine and the engine size:

Petrol Diesel LPG
up to 1400cc
1400cc-2000cc
over 2000cc

What formula do I need to pick up the value for one indivdual who drives a
diesel car with an engine size of 1600cc, or another who drives a petrol car
with an egine size of 1300cc? I am using Microsoft Excel 2003.

Thanks

two dimension look up table
 

Try this:

With
This table in A1:D4
(blank) Petrol Diesel LPG
0 1 2 3
1400 4 5 6
2001 7 8 9

F1: (an engine size)
G1: (a fuel type)
This formula returns the value at the intersection of
engine size and fuel type:
H1: =VLOOKUP(F1,$A$1:$D$4,MATCH(G1,$A$1:$D$1,0),1)

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"Dave Jepson" wrote:

Can anyone tell me how to lookup a value with two variable options. i am
specifically looking at a type of car engine and the engine size:

Petrol Diesel LPG
up to 1400cc
1400cc-2000cc
over 2000cc

What formula do I need to pick up the value for one indivdual who drives a
diesel car with an engine size of 1600cc, or another who drives a petrol car
with an egine size of 1300cc? I am using Microsoft Excel 2003.

Thanks