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 sure this is a simple fix but it lack of sleep is making it impossible to find the answer.
Could you assist?
3 Replies
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.
- Its that simple. Thanks!
