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
HansVogelaar it is great formula. i've just used this formula and it is working wonderful. I was searching this since a long,but now it is resolved. Thanks.