Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula to find highest value of a vlookup reference
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 "Gautam Agrawal" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I find the cell reference for a vlookup? | Excel Worksheet Functions | |||
Formula to find highest alphabetic name in a list of names | Excel Worksheet Functions | |||
Help! How do you get excel to find the x(changes daily, marked in a cell from another formula) highest numbers in a group of numbers and sum them up? | Excel Worksheet Functions | |||
Help! How do you get excel to find the x(changes daily, marked in a cell from another formula) highest numbers in a group of numbers and sum them up? | Excel Worksheet Functions | |||
Highest Value / Circular Reference Help | Excel Worksheet Functions |