How vlookup responds if it finds a duplicate value?

[dvm49]

I have two sheets (Data1 & Data2) and wanted to do a lookup on ID in Data1 against ID,Role in Data2. Data2 contains a duplicate ID with different roles. In this case, the vlookup that returns the value will be not relevant ?

 

[Hany ali]

HI,YOU can add iferror to your formula ...it will be

=IFERROR(VLOOKUP(B2,Array_Data2,2,FALSE),"")

 

[Fluff13]

Vlookup will return the first value it finds that matches. What do you want to happen if there are duplicates?

 

[pecoflyer]

In this case, the vlookup that returns the value will be not relevant ?

Could you please explain?
@Hany
IFERROR is a dangerous function to be used with precaution...