Vlookup and Hlookup Combine?

M

MyLan

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
 
T

T. Valko

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adding sequence numbers to paragraphs 0
HLOOKUP & VLOOKUP Combinded 4
Vlookup/Hlookup confusion 1
Hlookup & Vlookup 2
Hlookup/Vlookup with duplicate datas 0
SUM formula after HLOOKUP result true 9
vlookup and hlookup 4
Vlookup combined with Hlookup 7

Top