Jack

B

Bob Phillips

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)
 
J

Jack Sons

Bob,

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

Happy new year!

Jack.
 
B

Bob Phillips

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.

Bob
 
Top