Hello, I need some help with IF formula and duplicate values.
Basically, I have 2 sheets, in 1 sheet I have 1 column with names and 2 column with numbers, the second sheet is with a column with same names but with duplicates.
So, my problem is, whenever I put an IF formula or a combination with vlookup I get only 1 or 2 lines correct and the rest just shown as 0.
I would need that this sheet with duplicate names, to recognize names in the second sheet and write the numbers assigned to this specific name.
Can somebody help...

Thanks!

Ivana