ExcelBanter - Vlookup and Hlookup Combine?

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Vlookup and Hlookup Combine? (https://www.excelbanter.com/excel-worksheet-functions/190248-vlookup-hlookup-combine.html)

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

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