ExcelBanter - VLOOKUP

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - VLOOKUP (https://www.excelbanter.com/excel-worksheet-functions/211444-vlookup.html)

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

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

"steph44haf" wrote:

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

"steph44haf" wrote:

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