+ Reply to Thread
Results 1 to 8 of 8

Move corresponding data after finding matching part number

  1. #1
    Registered User
    Join Date
    04-15-2021
    Location
    New York, New York
    MS-Off Ver
    Microsoft Office 365
    Posts
    6

    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.



    Please help.
    Attached Files Attached Files
    Last edited by Robprez57; 04-16-2021 at 09:13 AM.

  2. #2
    Forum Expert
    Join Date
    09-07-2014
    Location
    Israel
    MS-Off Ver
    Office2010/office 365
    Posts
    2,190

    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. #3
    Registered User
    Join Date
    04-15-2021
    Location
    New York, New York
    MS-Off Ver
    Microsoft Office 365
    Posts
    6

    Re: Move corresponding data after finding matching part number

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

  4. #4
    Forum Expert
    Join Date
    09-07-2014
    Location
    Israel
    MS-Off Ver
    Office2010/office 365
    Posts
    2,190

    Re: Move corresponding data after finding matching part number

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

  5. #5
    Registered User
    Join Date
    04-15-2021
    Location
    New York, New York
    MS-Off Ver
    Microsoft Office 365
    Posts
    6

    Re: Move corresponding data after finding matching part number

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

  6. #6
    Forum Expert
    Join Date
    09-07-2014
    Location
    Israel
    MS-Off Ver
    Office2010/office 365
    Posts
    2,190

    Re: Move corresponding data after finding matching part number

    so why not using a simple vlookup then?

  7. #7
    Registered User
    Join Date
    04-15-2021
    Location
    New York, New York
    MS-Off Ver
    Microsoft Office 365
    Posts
    6

    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. #8
    Forum Expert
    Join Date
    09-07-2014
    Location
    Israel
    MS-Off Ver
    Office2010/office 365
    Posts
    2,190

    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)

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Move To Next Available Cell Matching Part Number Checking Duplicates
    By BobBrown60 in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 03-16-2021, 05:00 PM
  2. [SOLVED] Matching part of data in a cell
    By ExcelNerd2020 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-21-2020, 11:56 AM
  3. Finding ROW Number in range with partially matching data
    By losbol in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-04-2020, 06:19 AM
  4. matching row number value with part of file name
    By HeHeHaHa in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-17-2014, 04:07 PM
  5. Finding Matching Data in one Column/Adding corresponding matching string value.
    By swade730 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-02-2013, 07:23 PM
  6. Advanced lookup matching part of a number
    By MayfairBlue in forum Excel Formulas & Functions
    Replies: 24
    Last Post: 08-16-2012, 08:30 AM
  7. Replies: 10
    Last Post: 12-17-2009, 02:00 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1