Comparing 2 Columns which will determine which value from a 3rd column goes into col4

Hi

Been trying to solve this for a while now. I have two columns in seperate worksheets. One gives a list of accounts for a specific product and the other gives the list of all accounts and their respecive account managers.

I need the value in A1 of sheet 1 to be compared to A1:A2000 of sheet 2 and if it is in that column, column B in sheet 2 will be populated with the repective info (account address) from B2 of sheet 2.

Example is if Sheet 1 A1 is present in Sheet 2 A1:2000 then Sheet 1 B1 will equal Sheet 2 B1.

Any help is much appreciated.

Works a charm! Thank you.