If formula and duplicate values

[ibenic1]

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

[PaulM100]

Attach a sample file. To do so:
To attach a file to your post: (Please no pics or screenshots ... saves retyping data.),

be sure to desensitize the data
click “Go Advanced” (next to Post Quick Reply – bottom right),
scroll down until you see “Manage Attachments”, click that,
click “Browse”.
select your file(s)
click “Upload”
click “Close window”
click “Submit Reply”
The file name will appear at the bottom of your reply.

[ibenic1]

Hi,
Please see the example attachment.

[PaulM100]

I'm not sure if I understood, but this is what you want?
=VLOOKUP([@Name],Table1[[Name]:[Unique ID]],2,0)

[ibenic1]

Thank you soooo much for your help!
It works! This is what I needed! :D