Home |
Search |
Today's Posts |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Herz,
I would use the VLOOKUP function with a little trick to allow it for search with two arguments. First, I would make a table with all the possible combinations, in your case 10+4+6 rows. Let's say you have Type in column A, class in column B, then add a calculated column in C with the formula in C2: = A2&B2, then column D with the cost. Then, in the area where you want to automatically display the cost, use the formula: =VLOOKUP(F8&G8,C2:D19,2,0), where F8 is the cell containing the type and G8 the cell containing the class. C2:D19 represents the range with Type & Class, costs. Stephane. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Can an If statement answer an If statement? | Excel Discussion (Misc queries) | |||
IF STATEMENT | Excel Worksheet Functions | |||
appending and IF statement to an existing IF statement | Excel Worksheet Functions | |||
If statement and Isblank statement | Excel Worksheet Functions | |||
Help please, IF statement/SUMIF statement | Excel Worksheet Functions |