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