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