Forum Discussion
Vlookup to return highest value
Hi I have a database of all past prices and costs relating to specific parts number and need to be able to search and return the highest cost and prices based on a specific part number. I'm ...
In F4:
=MAXIFS($B$3:$B$14, $A$3:$A$14, E4)
If your version of Excel does not have MAXIFS, use
=MAX(IF($A$3:$A$14=E4, $B$3:$B$14))
and confirm the formula with Ctrl+Shift+Enter.
Similar in G4, but with $C$3:$C$14 instead of $B$3:$B$14
Its that simple. Thanks!