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 -