+ Reply to Thread
Results 1 to 2 of 2

Copied data cells from another worksheet based on PN field

  1. #1
    Registered User
    Join Date
    09-11-2012
    Location
    Tel Aviv
    MS-Off Ver
    Excel 2003
    Posts
    7

    Copied data cells from another worksheet based on PN field

    Hi Guys,

    I have an Excel with two worksheets, I needs to copy data from one worksheet to the other based on "P/N" column.
    The "list" worksheet should be automatically updated from the "catalog" worksheet with all required fields/ columns.
    The lines of two worksheets are not in same order or QTY, so it should lookup based only on P/N cell value.

    Attached an example file.

    Thanks
    Zadok

  2. #2
    Forum Contributor
    Join Date
    10-02-2012
    Location
    Bumi Nusantara
    MS-Off Ver
    Excel 2010; Excel 2016
    Posts
    136

    Re: Copied data cells from another worksheet based on PN field

    in cell C2 and D2 using array formula (1 row x 2 colums)
    Please Login or Register  to view this content.
    in cell F2 until H2 using array formula (1 row x 3 columns)
    Please Login or Register  to view this content.
    press CTRL Shift Enter, and copied down
    click the star if it solves your problem

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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