use Hlookup to look up two or more values
 

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

use Hlookup to look up two or more values
 

Give us some examples.


"tywlam" wrote:

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

use Hlookup to look up two or more values
 

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.



"Teethless mama" wrote:

Give us some examples.


"tywlam" wrote:

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

use Hlookup to look up two or more values
 

Try this:

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

Normally ENTER


"tywlam" wrote:

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.



"Teethless mama" wrote:

Give us some examples.


"tywlam" wrote:

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

use Hlookup to look up two or more values
 

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

"Teethless mama" wrote:

Try this:

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

Normally ENTER


"tywlam" wrote:

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.



"Teethless mama" wrote:

Give us some examples.


"tywlam" wrote:

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

use Hlookup to look up two or more values
 

replace COUNTA(A1:A4) to any row you want. If you want row 4 then enter 4


"tywlam" wrote:

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

"Teethless mama" wrote:

Try this:

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

Normally ENTER


"tywlam" wrote:

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.



"Teethless mama" wrote:

Give us some examples.


"tywlam" wrote:

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