For the LOOKUP formula to work as intended the lookup value, in this case 9^9
needs to be a number greater than any number that the FIND function will
return. Because the maximum number of characters in a cell is 32767 then 9^9
(387420489) more than fulfills that requirement.

Note: normally you would use equal sized ranges i.e.

=LOOKUP(9^9,FIND($F$2:$F$10,A5),$G$2:G10)



"Hardeep_kanwar" wrote:

What is the meaning of 9^9 in Below Function

=LOOKUP(9^9,FIND($F$2:$F$10,A5),$G$2:G13)

Thanks
Hardeep kanwar