View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Chuck M Chuck M is offline
external usenet poster
 
Posts: 54
Default 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.