On Jul 20, 4:05*am, 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)

It means "9 to the power of 9". It is a totally unnecessary
complication in this context, unless it has some cultural
significance. In this context, you want "a large number". Any large
number will do; better to use a constant like 1E+300 than an
expression that must be evaluated.

(By the way, 1E+300 is "scientific notation" for "1 times 10 to the
power of 300". It is very near the largest value that Excel permits
to be entered.)