+ Reply to Thread
Results 1 to 2 of 2

How do Match the ID numbers and get the related information in the next cell

  1. #1
    Registered User
    Join Date
    09-02-2022
    Location
    India
    MS-Off Ver
    2010
    Posts
    13

    How do Match the ID numbers and get the related information in the next cell

    How do Match the ID numbers and get the related information in the next cell in the respective row?
    My input is in sheet1 and the output is in sheet2. Data is up to 20000 rows. And product sub ID can be up to 150.
    Then can I serialize the ID as in the "serialize ID" Sheet?
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft? Excel? for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,005

    Re: How do Match the ID numbers and get the related information in the next cell

    Can you provide a complete list for 150 sub_ids ??

    (1)Add product information5, Add product information9, Add product information8, productID, Price.
    (2)Add product information5 Add product information9, Add product information8, Add product
    information, productID, Price.
    (3)Add product information6, Add product information7, Add product information, productID, Price.
    (4)Add product information6, Add product information7, productID, Price.
    (5)Add product information6, Add product information7, Add product information8, productID, Price.
    Last edited by JohnTopley; 09-02-2022 at 07:55 AM.
    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

+ 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. Activity Calendar - Cell won't populate (INDEX & MATCH related)
    By greentea in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 11-15-2018, 11:53 AM
  2. Replies: 1
    Last Post: 11-30-2016, 06:29 PM
  3. using prefix print the related information
    By kiran.nukala in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-04-2014, 08:42 PM
  4. [SOLVED] Trying to match partial string to an array, need to output related cell
    By vijaijohn in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-23-2013, 03:04 PM
  5. Replies: 3
    Last Post: 09-30-2012, 01:27 PM
  6. [SOLVED] index match with row information offset from the match cell
    By smls in forum Excel General
    Replies: 7
    Last Post: 08-30-2012, 09:48 AM
  7. [SOLVED] SUMIF other related field contains certain information
    By Sunantoro in forum Excel General
    Replies: 3
    Last Post: 09-19-2005, 05:05 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