Another one:

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

--
Biff
Microsoft Excel MVP


"Amanda" wrote in message
...
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?