| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
HLOOKUP question
Hi,
I need to know what column (or the relative position in the list) the result of an HLOOKUP came from. Is this possible? -- Thanks. Chuck M. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
HLOOKUP question
Try this:
=MATCH(lookup_value,A1:J1,0) Where A1:J1 = first row of your lookup table. -- Biff Microsoft Excel MVP "Chuck M" wrote in message ... Hi, I need to know what column (or the relative position in the list) the result of an HLOOKUP came from. Is this possible? -- Thanks. Chuck M. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
HLOOKUP question
The MATCH function returns the relative position of the sought item.
Hope this helps. Pete On Sep 27, 6:39 pm, Chuck M wrote: Hi, I need to know what column (or the relative position in the list) the result of an HLOOKUP came from. Is this possible? -- Thanks. Chuck M. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
HLOOKUP question
Just what I needed!
Thank you! -- Chuck M. "T. Valko" wrote: Try this: =MATCH(lookup_value,A1:J1,0) Where A1:J1 = first row of your lookup table. -- Biff Microsoft Excel MVP "Chuck M" wrote in message ... Hi, I need to know what column (or the relative position in the list) the result of an HLOOKUP came from. Is this possible? -- Thanks. Chuck M. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
HLOOKUP question
Works great!
Thanks Pete. -- Chuck M. "Pete_UK" wrote: The MATCH function returns the relative position of the sought item. Hope this helps. Pete On Sep 27, 6:39 pm, Chuck M wrote: Hi, I need to know what column (or the relative position in the list) the result of an HLOOKUP came from. Is this possible? -- Thanks. Chuck M. |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
HLOOKUP question
You're welcome. Thanks for the feedback!
-- Biff Microsoft Excel MVP "Chuck M" wrote in message ... Just what I needed! Thank you! -- Chuck M. "T. Valko" wrote: Try this: =MATCH(lookup_value,A1:J1,0) Where A1:J1 = first row of your lookup table. -- Biff Microsoft Excel MVP "Chuck M" wrote in message ... Hi, I need to know what column (or the relative position in the list) the result of an HLOOKUP came from. Is this possible? -- Thanks. Chuck M. |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
HLOOKUP question
You're welcome - I just pointed you to the function.
Pete On Sep 27, 7:10 pm, Chuck M wrote: Works great! Thanks Pete. -- Chuck M. "Pete_UK" wrote: The MATCH function returns the relative position of the sought item. Hope this helps. Pete On Sep 27, 6:39 pm, Chuck M wrote: Hi, I need to know what column (or the relative position in the list) the result of an HLOOKUP came from. Is this possible? -- Thanks. Chuck M.- Hide quoted text - - Show quoted text - |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| HLookUp | Excel Worksheet Functions | |||
| VLOOKUP or HLOOKUP function question | Excel Worksheet Functions | |||
| VLOOKUP / HLOOKUP Question | Excel Discussion (Misc queries) | |||
| HLOOKUP and SUM | Excel Discussion (Misc queries) | |||
| VLOOKUP/HLOOKUP Question | Excel Discussion (Misc queries) | |||
Linear Mode
