vlookup for all values in a column

[grkchakri]

Hi All
I have two sheets, sheet1 have only product code corresponding row should show the sales person names, these names are in sheet 2

Whenever we enter product code in range "a" the corresponding row in "B" should vlookup product code in sheet 2 and give the
sales person in corresponding "B".

This should continue whenever the product code in sheet1 is entered it should sales person name from sheet 2

if no name it should show N/A. i am able to doing vlookup individually

please advise how to proceed further on this