From few months, I have lost touch with excel formulas
The below is my data related vlookup in excel sheet.
The number is the main lookup value which appears in sheet1 and sheet3
However, in sheet 3 number and name appears
Please help me in updating the names in sheet 1 by doing vlookup for the values from sheet 3.
I have attached an excel sheet Example.xlsx for clear understanding of the issue
My vlookup formula =VLOOKUP(A2;Sheet3!A2:B30;2;0) did not help me in updating the names, as all the duplicate value numbers updated the names with #N/A values, please help me with a formula
Bookmarks