Fill a cell based on last entry
 

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?

Fill a cell based on last entry
 

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
--
Gary''s Student - gsnu200790


"Amanda" wrote:

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?

Fill a cell based on last entry
 

Wonderful....it worked! Thanks

"Gary''s Student" wrote:

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
--
Gary''s Student - gsnu200790


"Amanda" wrote:

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?

Fill a cell based on last entry
 

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?