View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Gautam Agrawal Gautam Agrawal is offline
external usenet poster
 
Posts: 1
Default formula to find highest value of a vlookup reference

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