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
|