VLOOKUP

[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

 

[Teethless mama]

Yes, It's always find the first one in a range.

 

[Shane Devenshire]

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