Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
HLOOKUP with 2 values and choose 1 value | Excel Worksheet Functions | |||
HLOOKUP and choose one value among 2 values | Excel Worksheet Functions | |||
HLookup returning values | Excel Worksheet Functions | |||
Summing HLookup Values | Excel Worksheet Functions | |||
Hlookup to return a sum of values | Excel Worksheet Functions |