Curious about formula

R

robert morris

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.
 
R

robert morris

Toppers,

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

Bob M.
 
B

bj

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.
 
R

robert morris

Bj,

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

Thanks again,

Bob M.
 
Top