want to get Maximum and Minimum value of selected codes using vlookup & MAX

Hi,

I need to get maximum and minimum value of selected codes. Used max&vlookup but it provides wrong result as shown in attached file.

need help to get correct result

Code Price Code for Max Max Should be
101212 55 101212 55 60
101212 60 101212 55 60
101212 12 101212 55 60
101213 16 101213 16 50
101213 40 101213 16 50
101213 50 101213 16 50
101213 30 101213 16 50
101215 78 101215 78 80
101215 80 101215 78 80

Formula was:
MAX(VLOOKUP(C2,$A$1:$B$17,2,FALSE))

Try this:

=MAX(IF($A$1:$A$17=C2,$B$1:$B$17))

... confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.

VLOOKUP will return the first match regardless - it cannot be coerced in the way you tried.