Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I link a cell outside a pivot table to one inside the table | Excel Discussion (Misc queries) | |||
Custom field in Pivot Table? | Excel Discussion (Misc queries) | |||
Pivot Table external XLS file source change and GETPIVOTDATA refresh | Excel Discussion (Misc queries) | |||
Derived Columns in Pivot Table | Excel Discussion (Misc queries) | |||
Change Data In Pivot Table | New Users to Excel |