Hi All
I am trying to find a position of the value in given in B17(EX:1000) but what i dont know is the Lookup Array because my value is a part of range (Ex:A1:O14)
=match(B17, lookup_array, 0)
How do we tackle the situation look up array when we dont know which column / row it is in.
usually lookup array we hard code(though not in all scenarios) it like A1:O1 / A5:O5 or so on
My excel verison:2007
Many thank
Bookmarks