combining column number and hlookup

hi

i'm performing an hlookup of a single value, where the value can be found in any column within the lookup row.

is there way to return the column that the lookup value was found in?

thanks

If your hlookup was something like

=HLOOKUP("x",A1:Z2,2,0)

then you can find the number of the column with

=MATCH("x",A1:Z1,0)

e.g. if "x" is found first in F1 this will give 6

If you actually want to return "F" then try

=SUBSTITUTE(ADDRESS(ROW(A1),MATCH("x",A1:Z1,0),4),ROW(A1),"")