H/VLookup to return a column or row number

[Lauren]

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

to return the column number?

thanks for any help

Lauren

 

[Biff]

Hi Lauren,

Here's one way:

=MATCH(A44,2:2,0)

Biff

 

[Lauren]

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