=LOOKUP(2^15,SEARCH('1'!$A$2:$A$995,K2),'1'!$B$2:$B$995)
Can any one give me a clue was to what the purpose of 2^15 is in this lookup formula?
Obviously I know that from searching or clicking in the formula it is the lookup value but why could this number be so high. Obviously I don't understand the methodology behind this lookup. I don't see what this couldn't be 1 or 25... just as easy as 32768.
Can someone help me with this???
Bookmarks