View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default 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.