use Hlookup to look up two or more values

  • Thread starter Thread starter tywlam
  • Start date Start date
T

tywlam

How do I use hlookup to look up two or more values on the top rows and return
a value in the same column from a row specified? (hlookup allows to look up
one value only!)

Please help. Thanks
 
eg.
A B C
1 t r u
2 k w y
3 x t j
4 h g k

I want to lookup values "r" and "w" from the first two rows in the same
column and return value from row 4. In this example, the returned value
should be "g". How can I use hlookup or other functions to do it?

Thanks.
 
Try this:

=INDEX(A1:C4,COUNTA(A1:A4),MATCH(1,INDEX((A1:C1="r")*(A2:C2="w"),),))

Normally ENTER
 
thanks. but where can i specify in this formula the row from which the value
is returned?
 

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

Back
Top