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.

Curious about formula
 

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.

Curious about formula
 

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.

Curious about formula
 

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.

Curious about formula
 

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.