How do I import data from another sheet to match certain criteria?

[wn4180]

I need to take the data from column C (‘Audit Code’) in Sheet Y and import it to match the employee in column C on sheet X (‘Name’). The final result should look like sheet Z

• Each ‘Audit Code’ is assigned to a specific Employee Name
• There are hundreds of names and not all names will be used every time

Thanks for your assistance. This is my first post on any type of forum. I appreciate your patience.

[scottylad2]

slight adaptation of a code I posted a short while ago, think this does as you wish

=INDEX(AuditCodeImpList,MATCH(B2&C2,INDEX('Sheet Y'!$A$2:$A$35&'Sheet Y'!$B$2:$B$35,,),0))

My assumption is that an employee, employee number and audit code will always stay the same.

I also named the range C2:C35 on sheet Y AuditCodeImpList for ease of eye

[wn4180]

Thank you for your assistance. I really appreciate it. Can you give me a little more detail on where I should place the formula and any other novice advice of this issue?

Your are correct that the employee, employee number and audit codes will remain the same.

[scottylad2]

Not able to access a pc right now, on a phone I'm afraid. First off do this on sheet y C2:C35 on sheet Y highlight these cells, and in the name box type tthe following hen press enter AuditCodeImpList

In sheet Y where you require the Audit column, paste in the formula from above directly beneath Audit then copy down as far as you need it.

[wn4180]

Thank you so much, scottylad2! You are my "hero of the week"! Have a great day!!