dvm49 Member May 25, 2020 #1 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 ? Attachments Vlookup.xlsx Vlookup.xlsx 11.9 KB · Views: 6
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 ?
H Hany ali Active Member May 25, 2020 #2 HI,YOU can add iferror to your formula ...it will be Code: =IFERROR(VLOOKUP(B2,Array_Data2,2,FALSE),"") Attachments Vlookup1.xlsx Vlookup1.xlsx 17.3 KB · Views: 4
HI,YOU can add iferror to your formula ...it will be Code: =IFERROR(VLOOKUP(B2,Array_Data2,2,FALSE),"")
F Fluff13 Active Member May 25, 2020 #3 Vlookup will return the first value it finds that matches. What do you want to happen if there are duplicates?
Vlookup will return the first value it finds that matches. What do you want to happen if there are duplicates?
pecoflyer Well-Known Member May 25, 2020 #4 In this case, the vlookup that returns the value will be not relevant ? Click to expand... Could you please explain? @Hany IFERROR is a dangerous function to be used with precaution...
In this case, the vlookup that returns the value will be not relevant ? Click to expand... Could you please explain? @Hany IFERROR is a dangerous function to be used with precaution...
