Vlookup (pickup the last row...
 

Wonder if anyone can help me out.

As follow is the formula I use for my worksheet.
=VLOOKUP(D3,'Class'!$A$2:$J$500,3,FALSE)

It returns the value in third column of the Class sheet.. The problem is
sometimes there are two or three or more values for the individual on the
third column of the Class sheet, and the formula always pick up the first
value for the individual.

My question is how do I change the formula so it will pick up the last value
not the first one.

Thanks,
Aline
--
Aline

Vlookup (pickup the last row...
 

Try

=LOOKUP(2,1/(Class!A2:A500=D3),Class!J2:J500)

Mike

"Aline" wrote:

Wonder if anyone can help me out.

As follow is the formula I use for my worksheet.
=VLOOKUP(D3,'Class'!$A$2:$J$500,3,FALSE)

It returns the value in third column of the Class sheet.. The problem is
sometimes there are two or three or more values for the individual on the
third column of the Class sheet, and the formula always pick up the first
value for the individual.

My question is how do I change the formula so it will pick up the last value
not the first one.

Thanks,
Aline
--
Aline

Vlookup (pickup the last row...
 

I misread your post try this instead

=LOOKUP(2,1/(Class!A2:A500=D3),Class!C2:C500)

Mike

"Mike H" wrote:

Try

=LOOKUP(2,1/(Class!A2:A500=D3),Class!J2:J500)

Mike

"Aline" wrote:

Wonder if anyone can help me out.

As follow is the formula I use for my worksheet.
=VLOOKUP(D3,'Class'!$A$2:$J$500,3,FALSE)

It returns the value in third column of the Class sheet.. The problem is
sometimes there are two or three or more values for the individual on the
third column of the Class sheet, and the formula always pick up the first
value for the individual.

My question is how do I change the formula so it will pick up the last value
not the first one.

Thanks,
Aline
--
Aline