Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Max using Index/Match Help
I'm trying to create a function using Index/Match to qualify my criteria to
extract the highest value in a field (and I'm having fits doing it!). I can't use VLookup because my lookup list is, and cannot be, in alphabetical order. My fields are as follows: A B 1 Check number Check Amt 2 12345 $100 3 12345 $200 4 12345 $300 I'm using the check numbers (another sheet, say, at cell D2) as the Lookup Value against the Check Number field (above). When a Match is found I need the highest value from the Check Amt field returned. Thank you! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
INDEX/MATCH Functions with row-arranged table. | Excel Worksheet Functions | |||
Index/Match in VBA | Excel Discussion (Misc queries) | |||
Index/Match not working | Excel Worksheet Functions | |||
Index/Match Help | Excel Discussion (Misc queries) | |||
Index/Match to look up a value in one workbook and insert it into. | Excel Discussion (Misc queries) |