I thought it does return the first one if you put the parameter "False" as
the fourth parameter.

I'm sure someone has a cleverer formula, but you could sort by company, then
descending by the yes/no column?

Daniel

"Ash" wrote:

doing a vlookup on company name - it may appear numerous times in the
spreadsheet I am looking up from, but I can't tell how it determines which
value to return. For example, Company ABC listed in 4 rows, 3 of which have
"no" and 1 has "yes". I want the yes. I have sorted alphabetically,
thinking it returns the first one. Need advice. Thanks.....Ash