Which result will I get if VLOOKUP finds more than one match?

Answer 1

It depends on the match type argument.

if you perform EXACT match, VLOOKUP will stop at the first match.

if you perform APPROXIMATE match, VLOOKUP will assume they are sorted in ascending order, and will stop at the last match (because it goes past the last one, and backs up one spot).