Curious about formula

[Guest]

I needed to copy the last value in a column to another cell. Last value in
column G (which changes) needs to also show in Cell F36. Found help on this
formula in previous posts. This works perfectly. What I would like to know
is what does 99^99 mean?


=LOOKUP(99^99,G:G)

Thanks,

Bob M.

 

[Guest]

99 raised to the power 99 ( a very large number!)

3^2 =3*3

4^3=4*4*4

 

[Guest]

Toppers,

I thought that might be the case, but the huge number threw me. Many thanks
for the answer.

Bob M.

 

[Guest]

normally lookup requires the table to in assending order
but if the lookup number is higher than anything in the list, it will
respond with the last number it sees.

 

[Guest]

Bj,

Even more information! I love it and appreciate all the help available on
this site.

Thanks again,

Bob M.