Hi all,
I need help creating a formula to move data on one spreadsheet to another that has a matching part number.
For example I have two separate spreadsheets one is (Sheet 1) a master list with all customer products, the other is (Sheet 2) for one specific customer. I need to add the product descriptions from each corresponding part from Sheet 2 to Sheet 1. Since I have over 19000 products with 2500 or so missing a description from Sheet 1 I would prefer not to go line by line copy and pasting from one sheet to another and was hoping there is a formula I could use in Sheet 1 to match the part numbers from Sheet 1 to the part numbers in Sheet 2 and then copy the description from Sheet 2 to Sheet 1. I have done something similar with Sumif (=SUMIF(Sheet2!A:A,A2,Sheet2!C:C))to move sales from one sheet to another, but sumif doesn't work with text.
Please help.
Bookmarks