Fill a cell based on last entry

[Amanda]

I have a worksheet that I need to pull a number from Column b, but the row
number is based on the last entry of a cell, is this possible?

For example:

A B C
1 25% 12500
2 40% 1500
3 75% 1400
4 100%
5

In A5, I'd like the number from B3 to go, since the last entry inc olumn C
is in C3.

Does this make sense?

 

[Gary''s Student]

In A5:

=OFFSET($B$1,MATCH(9.99999999999999E+307,C:C)-1,0)

basically, go down from B1 as far as there is data in column C

 

[Amanda]

Wonderful....it worked! Thanks

In A5:

=OFFSET($B$1,MATCH(9.99999999999999E+307,C:C)-1,0)

basically, go down from B1 as far as there is data in column C

 

[T. Valko]

Another one:

=LOOKUP(1E100,C:C,B:B)