Sorry if this request seems rather basic to most or the description of what I want vague, I am rather new to using excel for manipulating my data.



Essentially I want to do something similar to a VLOOKUP (maybe not but this is the function I know).
Lookup a value within a range of data but then I want the formula to return the greatest value out of the return cells.
I would also like to find the lowest value but as a separate formula.

E.g.
You have a sheet with "Part Numbers" in Column A, "Quantity" in Column B.
I want to be able to lookup a part number and return the highest quantity of that part in the data range.
In a second formula I want to return the lowest.
Assume a part number will appear within the data range multiple times but with different quantities.

Thank you in advance for any and all help