# Move corresponding data after finding matching part number

1. ## Move corresponding data after finding matching part number

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.

2. ## Re: Move corresponding data after finding matching part number

Hi
The part numbers in your sheet1 do not exist in sheet 2....
is this supposed to be like that?

3. ## Re: Move corresponding data after finding matching part number

No. I apologize this has been corrected in the attached.

4. ## Re: Move corresponding data after finding matching part number

Hi
Is the part# unique, or can show few times with different description?

5. ## Re: Move corresponding data after finding matching part number

The part number is unique, and will only show once on the list.

6. ## Re: Move corresponding data after finding matching part number

so why not using a simple vlookup then?

7. ## Re: Move corresponding data after finding matching part number

I have never used vlookup, and am not sure how to type out that formula.

8. ## Re: Move corresponding data after finding matching part number

OK, if you know to use SUMIF , VLOOKUP will be very simple for you.

B2 and down:
=VLOOKUP(A2,Sheet2!A:B,2,0)

There are currently 1 users browsing this thread. (0 members and 1 guests)