formula to find highest value of a vlookup reference

  • Thread starter Thread starter Gautam Agrawal
  • Start date Start date
G

Gautam Agrawal

Hi My name is Gautam. I discoverd so many question in archieve but did not
get my answer. My query is, I want to vlookup only the MAX VALUE OF vlookup.
i.e. if I vlookup AX the result should be 2
A B

AX 1
AX 2
AY 1
AY 2
AY 3
 
Hi,

Try this
=MAX(IF($A$1:$A$5="AY",$B$1:$B$5))

This is an array so must be cimmited with CTRL+Shift+Enter NOT just enter
If you dom it correctly Excel wil put curly braces {} around the formula.
You can't type these yourself.

Mike
 
Back
Top