VLOOKUP

  • Thread starter Thread starter steph44haf
  • Start date Start date
S

steph44haf

What happens if there are two of the same values in your search area when
using the vlookup funciton? Does it find the first one and use that row? It
seems to be working that way but I want to make sure.

Thanks,

Steph
 
Hi,

The answer is it depends, consider the following data

Shane 123
Marsha 2
Shane 567
Marsha 1

=VLOOKUP("shane",F1:G4,2,1)
Returns 567
=VLOOKUP("shane",F1:G4,2,0)
Returns 123

So sort order and match type affect the results.

If this helps, please click the Yes button.

Cheers,
Shane Devenshire
 
Back
Top