Hi,

I have been trying for hours and I'm sure this is basic for most people out there.

I have a spreadsheet all on the one sheet. I have a sheet called employee skills which has a list of employees with an id and the skill name and the skill description. There can be multiples of the same skill name and employee id. As an employee can have more than one skill.

Then I have another sheet which is called skills has has skill id, skill name and skill description.

I need to grab the skill id from sheet skill and compare against the employee skills name and skill skill name to get the skill id.

So to make it clearer. I have the two below sheets. I need skill id to appear in column D of employee skill if the two skill names match.

Employee Skill
A B C D
Payroll Skill Skill Description
123 Excel MS Excel
124 Word MS Word

Skill
A B C
SkillID Skill Skill Description
1 Excel MS Excel
2 Word MS Word

Thanks for any assistance