Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Jack
Jack,
I think I mis-read what you wanted to do. Try this formula instead =INDEX(H2:H20,MATCH(MAX(IF(ISNUMBER(MATCH(G2:G20,{ "RST","ABC"},0)),E2:E20)), E2:E20,0)) which is an array formula, so commit with Ctrl-Shift-Enter. -- HTH RP (remove nothere from the email address if mailing direct) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
array in VBA | Excel Discussion (Misc queries) | |||
how do i simulate a king queen or jack playing card in excel assum | Excel Discussion (Misc queries) | |||
roundoff when converting text to numbers | Excel Worksheet Functions | |||
Changing cell value with arrows (?) | Excel Discussion (Misc queries) | |||
Macro to simply bring up the Find dialogue box?? | Excel Discussion (Misc queries) |