+ Reply to Thread
Results 1 to 3 of 3

looking up data from multiple columns and stacking them into one column

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

    looking up data from multiple columns and stacking them into one column

    Hi, I am trying to do a lookup from column A on sheet A and against the columns A-C on sheet B, to return the data in columns G-I on sheet B as A relates to G, B relates to H and C relates to I.

    The sample I killed the formulas on sheet B but they are all sequence formulas so the numbers are dynamic and spill down depending on other criteria. That being said, columns A-C are all related to each other so there will be no duplicate numbers in either column.

    I'm not sure if this makes sense but if anyone can assist, that would be great. I would also like to avoid VBA unless its super simple.
    Attached Files Attached Files
    Last edited by ivega29; 01-12-2021 at 03:25 PM.

  2. #2
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,580

    Re: looking up data from multiple columns and stacking them into one column

    This only works if your IDs on sheet b are unique.
    For convenience, I created 3 named ranges, MyIDs, MyDates, and MyEvents
    on sheet b,
    MyIDs = A2:F45
    MyDates = G2:L45
    MyEvents = M2:R45
    Then, in sheet a, B2 copied down
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    in C2 copied down
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Attached Files Attached Files
    ChemistB
    My 2

    substitute commas with semi-colons if your region settings requires
    Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
    If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)

    Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble

  3. #3
    Registered User
    Join Date
    01-12-2021
    Location
    New York, New York
    MS-Off Ver
    Office 365
    Posts
    6

    Re: looking up data from multiple columns and stacking them into one column

    this worked! thanks!

+ 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. Taking multiple columns and stacking in to one column
    By caripinkert in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-22-2019, 07:33 PM
  2. stacking multiple columns into one
    By niktodorov1 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 07-09-2018, 01:18 PM
  3. [SOLVED] Stacking several columns into one column on another worksheet
    By redrocker12 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 05-17-2018, 05:57 PM
  4. [SOLVED] Stacking data from multiple columns.
    By paularthur90 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-27-2016, 05:15 AM
  5. Replies: 3
    Last Post: 11-14-2015, 03:48 PM
  6. Combining Multiple Columns without stacking
    By ATowne20 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-05-2013, 01:41 PM
  7. Stacking columns across multiple sheets
    By mstinson23 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-28-2009, 03:08 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