HLOOKUP question

[Chuck M]

Hi,

I need to know what column (or the relative position in the list) the result
of an HLOOKUP came from. Is this possible?

 

[T. Valko]

Try this:

=MATCH(lookup_value,A1:J1,0)

Where A1:J1 = first row of your lookup table.

 

[Pete_UK]

The MATCH function returns the relative position of the sought item.

Hope this helps.

Pete

 

[Chuck M]

Just what I needed!

Thank you!
--
Chuck M.

Try this:

=MATCH(lookup_value,A1:J1,0)

Where A1:J1 = first row of your lookup table.

 

[Chuck M]

Works great!

Thanks Pete.
--
Chuck M.

The MATCH function returns the relative position of the sought item.

Hope this helps.

Pete

 

[T. Valko]

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP

Just what I needed!

Thank you!

 

[Pete_UK]

You're welcome - I just pointed you to the function.

Pete