software

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,{ quot;RSTquot;,quot;ABCquot;},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)

Bob,

Without assistance from people like you working with Excel would be like
crossing on foot the Gobi desert.

Happy new year!

Jack.

quot;Bob Phillipsquot; gt; schreef in bericht
...
gt; Jack,
gt;
gt; I think I mis-read what you wanted to do. Try this formula instead
gt;
gt; =INDEX(H2:H20,MATCH(MAX(IF(ISNUMBER(MATCH(G2:G20,{ quot;RSTquot;,quot;ABCquot;},0)),E2:E20)),
gt; E2:E20,0))
gt;
gt; which is an array formula, so commit with Ctrl-Shift-Enter.
gt;
gt; --
gt;
gt; HTH
gt;
gt; RP
gt; (remove nothere from the email address if mailing direct)
gt;
gt;
gt;
Jack,

Sorry about the subject, don't know what happened there, but at least you
found it.

Happy New Year to you, and my many friends in the Netherlands.

Bobquot;Jack Sonsquot; gt; wrote in message
...
gt; Bob,
gt;
gt; Without assistance from people like you working with Excel would be like
gt; crossing on foot the Gobi desert.
gt;
gt; Happy new year!
gt;
gt; Jack.
gt;
gt; quot;Bob Phillipsquot; gt; schreef in bericht
gt; ...
gt; gt; Jack,
gt; gt;
gt; gt; I think I mis-read what you wanted to do. Try this formula instead
gt; gt;
gt; gt;
=INDEX(H2:H20,MATCH(MAX(IF(ISNUMBER(MATCH(G2:G20,{ quot;RSTquot;,quot;ABCquot;},0)),E2:E20)),
gt; gt; E2:E20,0))
gt; gt;
gt; gt; which is an array formula, so commit with Ctrl-Shift-Enter.
gt; gt;
gt; gt; --
gt; gt;
gt; gt; HTH
gt; gt;
gt; gt; RP
gt; gt; (remove nothere from the email address if mailing direct)
gt; gt;
gt; gt;
gt; gt;
gt;
gt;