| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Vlookup in vlookup - taking the result as array name | Excel Worksheet Functions | |||
| Combine VLOOKUP and IF function so #NA isn't returned as a value from VLOOKUP | Excel Discussion (Misc queries) | |||
| Vlookup -=VLOOKUP(F9,LookUp1!$A$2:$B$1504,2,FALSE) | New Users to Excel | |||
| Vlookup info being used without vlookup table attached? | Excel Worksheet Functions | |||
| pickup cell value according another cell value | Excel Worksheet Functions | |||
Hybrid Mode
