find LAST match in column

P

Pantryman

Hi Domenic and Aladin,

the lookop solution worked but indeed not completely.
The

=INDEX(B1:B1000,MAX(IF(A1:A1000="Jack",ROW(A1:A1000))))

gives a parameter list error.

Both column A and B contain empty cells. Could that be the problem?

Any other ideas maybe?
 
D

Domenic

Pantryman said:
Hi Domenic and Aladin,

the lookop solution worked but indeed not completely.
The

=INDEX(B1:B1000,MAX(IF(A1:A1000="Jack",ROW(A1:A1000))))

gives a parameter list error.

Both column A and B contain empty cells. Could that be the problem?

Any other ideas maybe?
Click to expand...

I'm not sure why you're getting that error, but make sure that you
enter the formula using CONTROL+SHIFT+ENTER and not just ENTER...

=INDEX(B:B,MAX(IF(A1:A1000="Bob",ROW(A1:A1000))))

Having said that, I would use the following formula instead that needs
to be entered using just ENTER...

=LOOKUP(2,1/(A1:A100="Bob"),B1:B100)

As Harlan has already pointed out, the formula is more efficient.
 
Top