Jack

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

[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.

"Bob Phillips" <[email protected]> schreef in bericht
news:uEye%[email protected]...
> 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)
>
>
>

[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


"Jack Sons" <[email protected]> wrote in message
news:[email protected]...
> Bob,
>
> Without assistance from people like you working with Excel would be like
> crossing on foot the Gobi desert.
>
> Happy new year!
>
> Jack.
>
> "Bob Phillips" <[email protected]> schreef in bericht
> news:uEye%[email protected]...
> > 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)
> >
> >
> >
>
>