VLOOKUP

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
 
S

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Use & with two formulas 2
Vlookup to reference offset 1
Searching the formula (not the value) for a text string 1
Dragging a formula down isn't working - where am I going wrong? 1
Avoiding redundant calculations 7
Vlookup and return sheet name also 2
VLOOKUP duplicate values in table the table array? Help me solve 1
VLookup Won't Copy down (#REF! error) 1

Top