| 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 |
| 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 | |||
Threaded Mode
