0 (or False) means that it has to be an exact match.

ref at heart wrote:

Thank you Dave,
Works perfect
Question, what is the 0 for?

"Dave Peterson" wrote:

=index(a2:a17,match(large(g2:g17,1),g2:g17,0))

max(g2:g17)
instead of:
large(g2:g17,1)
would work for the largest match, too.

ref at heart wrote:

A2:A17 is a list of names on a team
G19 is a "=LARGE(G2:G17,1)" formula and then second and third highest
What I would like to do is get the corresponding name to match up with the
large 1 number
I've tried many, closets is =lookup(G19,G2:G17,A2:A17)
All this does is give me the name in A17
help please

--

Dave Peterson


--

Dave Peterson