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.

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

3^2 =3*3

4^3=4*4*4

"robert morris" wrote:


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.

"Toppers" wrote:

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

3^2 =3*3

4^3=4*4*4

"robert morris" wrote:


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.

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.

"robert morris" wrote:


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.

Bj,

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

Thanks again,

Bob M.


"bj" wrote:

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.

"robert morris" wrote:


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.