look up data from one worksheet to match to another.

Hi all,

I'm a complete beginner in excel but I'm trying to get better. Can’t get my head around this. In the example file attached there are 2 worksheets. In the first i have 2 columns the agent ID and accompanying name. In the first worksheet I have 2 columns with agent ID and corresponding name. In the second worksheet I have 3 columns and I need a formula that will take the IDs that match from each worksheet and auto fill the correct name. It will be pretty clear what I need when you see the example anyways.

Look Up Example.xls

Thank you in advance for any assistance!