+ Reply to Thread
Results 1 to 2 of 2

Match and Plug

  1. #1
    Registered User
    Join Date
    11-19-2019
    Location
    Kent, Washington
    MS-Off Ver
    2016
    Posts
    1

    Post Match and Plug

    Hey All,
    Would appreciate your help here.
    Please see the attached excel file.
    My problem statement is rather simple, but I was hoping that someone could guide me here;
    The first tab in the file (titled "Data Set") has 4 part types (P1,P3...) listed in the first row. The numbers below in each column are specific to that part type only.
    On the second tab in the file (titled " Placement Sheet") I have only the part types in the first row, which are arranged randomly.

    My task is to figure out where each part type of the "Data Set", is located on the "Placement Sheet", and subsequently copy the numbers on the "Placement Sheet" under the correct part type.
    This is the sample data , but in reality I'm dealing with 100s of part types on the "Placement Sheet" and so wanted to know if this can be done quickly via Index &Match (perhaps using arrays?) or a quick vba code?

    Your help is much appreciated.
    Kind Regards,
    Avi
    Attached Files Attached Files

  2. #2
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,122

    Re: Match and Plug

    Welcome to the Forum gupta425

    Please Login or Register  to view this content.
    Good Luck
    I don't presume to know what I am doing, however, just like you, I too started somewhere...
    One-day, One-problem at a time!!!
    If you feel I have helped, please click on the star to left of post [Add Reputation]
    Also....add a comment if you like!!!!
    And remember...Mark Thread as Solved.
    Excel Forum Rocks!!!

+ 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. If cell E F G have #N/A plug C
    By makinmomb in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-12-2018, 06:40 AM
  2. Auto-refresh using API plug-in
    By ahazeldene in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-19-2018, 02:53 PM
  3. [SOLVED] plug true , if format 000.000.00
    By makinmomb in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 06-10-2014, 02:12 PM
  4. Excel Plug-in ?
    By Lukael in forum Excel General
    Replies: 0
    Last Post: 03-16-2014, 11:24 AM
  5. Plug Variables into Formula
    By ProjectChaosX in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-11-2012, 09:22 PM
  6. Excel Chart plug-in
    By nmss18 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-14-2010, 04:26 AM
  7. Graphing Software Plug-Ins
    By JoshLosAngeles in forum Excel General
    Replies: 0
    Last Post: 06-20-2005, 05:05 PM

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