Matt Lennertz
asked on
Lookup Max value with criteria
i'm trying to pull back the maximum mileage on a vehicle from a fuel system dump.
The data is on the left of the screen shot, the summary page is on the right.
i need to do a lookup using the unit number (truck number) from the summary to the data to return the max mileage (current mileage) on each vehicle.
=MAX(VLOOKUP(B4,DataDump!C :F,4,FALSE )) only returns me the first value on the mileage for that truck number not the greatest.
any help would be greatly appreciated.
screenshot.bmp
The data is on the left of the screen shot, the summary page is on the right.
i need to do a lookup using the unit number (truck number) from the summary to the data to return the max mileage (current mileage) on each vehicle.
=MAX(VLOOKUP(B4,DataDump!C
any help would be greatly appreciated.
screenshot.bmp
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.