Match and move data from one worksheet to another

[dwood]

I have two separate worksheets. Worksheet one contains two columns of data. Column A of worksheet one contains a product number and column B contains a product definition. Column A of Worksheet two contains a product number. I am trying to write an Array formula that will compare the data in column A of worksheet two with column A of worksheet one and when it finds a match, copy the definition in column B of worksheet one to column B of worksheet 2.

 

[VoG]

Try VLOOKUP http://www.contextures.com/xlFunctions02.html

 

[dwood]

VoG - I have tried VLOOKUP and either I am not entering the information correctly, or it is not working in this scenario.

 

[VoG]

In what way is it "not working"?

 

[dwood]

VoG - As usual, it was me. When I entered the information in the VLOOKUP function correctly, it worked as it was designed to work. Thanks for your help.