Curious about formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
Toppers,

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

Bob M.
 
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.
 
Bj,

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

Thanks again,

Bob M.
 
Back
Top