| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup and Hlookup Combine?
Hi,
I have a table like this: Model Option 1 Option 2 Option 3 A $10 $15 $5 B $20 $17 $5 C $30 $19 $5 Now i want to find the value of the Model A and Option 3 or Model A and Option 1 or so on... Would any one can help me to create an formula which combine the vlookup and Hlookup together... Much appreciated. Thanks, MyLan |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Vlookup and Hlookup Combine?
With your table in the range A1:D4...
F2 = model lookup = A G2 = option lookup = option 3 =VLOOKUP(F2,A1:D4,MATCH(G2,A1:D1,0),0) -- Biff Microsoft Excel MVP "MyLan" wrote in message ... Hi, I have a table like this: Model Option 1 Option 2 Option 3 A $10 $15 $5 B $20 $17 $5 C $30 $19 $5 Now i want to find the value of the Model A and Option 3 or Model A and Option 1 or so on... Would any one can help me to create an formula which combine the vlookup and Hlookup together... Much appreciated. Thanks, MyLan |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| lookup combine vlookup with hlookup | Excel Worksheet Functions | |||
| Can you combine VLOOKUP with a nest HLOOKUP? | Excel Discussion (Misc queries) | |||
| Combine Vlookup and Hlookup | Excel Worksheet Functions | |||
| Do I need to combine hlookup and countif????? | Excel Worksheet Functions | |||
| HLookup, IF statement, multiple sort, somehow combine all of these | Excel Worksheet Functions | |||
Hybrid Mode
