R
robotman
I'm doing a simple HLOOKUP and would like to know what column a
matching value is in rather than the value of something else in a
nearby row.
For example if I have:
apple orange pear
in columns 1, 2, and 3 respectively, how do I do a search for "orange"
and then return the column number "2" as the match?
Thanks for any ideas!
matching value is in rather than the value of something else in a
nearby row.
For example if I have:
apple orange pear
in columns 1, 2, and 3 respectively, how do I do a search for "orange"
and then return the column number "2" as the match?
Thanks for any ideas!