H/VLookup to return a column or row number

Lauren · Oct 30, 2003

Hi!
How can I do a:
=HLOOKUP(A44,2:2,COLUMN(),FALSE)

to return the column number?

thanks for any help

Lauren

Biff · Oct 30, 2003

Hi Lauren,

Here's one way:

=MATCH(A44,2:2,0)

Biff

Lauren · Oct 30, 2003

Hi Biff,
Thanks, I've tried that one, but I have hidden cells above
the list.

Thanks again, I'll post again more clearly when I can.
Sorry.

Thank you
Lauren