Help with VLOOKUP

Question

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.

lorenzo kim · Answer

pls see attached file.hope this is what you're looking for.thanks..

brad hepper · Answer

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

lorenzo kim · Answer

pls find the attached file..

lorenzo kim · Answer

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

lorenzo kim · Answer

pls see attached revised file..

Forum Discussion

Help with VLOOKUP

Share

Resources