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.
|