Help with VLOOKUP

[Brad Hepper]

I have a worksheet which contains 2 sheets, Sheet 1 is for adding/listing parts to order and Sheet 2 is a list of Part Numbers & their Descriptions.  

If data entered into Column B in Sheet 1 matches data from Column A in Sheet 2 I would like it to return text from Column B in Sheet 2 to Column C in Sheet 1.

If S1:B=S2:A then S2:B->S1:C

I have the columns labeled on Sheet 2: A=PartNumber & B=Description if that is of any help.

[#2]

pls see attached file.

hope this is what you're looking for.

thanks..

[#3]

Yes that is what I am looking for.  Could you do something similar using the file already created?

[#4]

pls find the attached file..

[#5]

I noticed just now that your validation lists has many duplicates. it is rather odd to have such duplicates...

[#6]

pls see attached revised file..