Cell offset issue

[MGarrison]

HI,

I am trying to have a row that references cells that are moving 1 down and 1
over. I want to caputure the last number in each column.

Example


A1 4 B1 C1
A2 7 B2 8 C2
A3 9 B3 4 C3 15
A4 B4 6 C4 10
C5 12

I am trying to create a row that will read
A6 9 B6 6 C6 12

NOT

A6 9 B6 4 C6 15

Thanks

 

[T. Valko]

Enter this formula in A6 and copy across:

=LOOKUP(1E100,A1:A5)

 

[MGarrison]

TY.

What doe the 1e100 mean?

 

[David Biddulph]

1E100 means 10 to the power of 100, or 1 followed by 100 zeroes, in other
words, a large number.

More generally, 1.2345E67 means 1.2345 multiplied by (10 to the power of 67)
or in Excel terms =1.2345*10^67