View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
robert morris robert morris is offline
external usenet poster
 
Posts: 222
Default Curious about formula


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.