1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Lookup with Multiple records on Large database

Discussion in 'Business Applications' started by jay201, Jan 20, 2013.

Thread Status:
Not open for further replies.
  1. jay201

    jay201 Thread Starter

    Joined:
    Jan 20, 2013
    Messages:
    2
    I have a table of data A-C and column A has the unique identifier that will match on my next table of data Column E-F

    Column A might have more data than Column E, let's say Column A has 5 of the same data, Column E might just have 3, I want the data on the 2nd table for the 3 pieces of information to to be pulled across to table 1 in 3 rows, the next 2 rows will remain blank.

    I've tried using the INDEX Match, but it only returns the first rows of data and on multiple occasions

    I've attached a copy of my template with what I've done so far, can someone please help, thank you.

    Junior
     

    Attached Files:

  2. Garf13LD

    Garf13LD

    Joined:
    Apr 17, 2012
    Messages:
    455
    :D:D:D
     

    Attached Files:

  3. jay201

    jay201 Thread Starter

    Joined:
    Jan 20, 2013
    Messages:
    2
    Garf13LD, you're amazing, I used to think I knew excel good, man you're insanely awesome, thank you soooo much, you don't know how much this means to me, if there's anything I can do for you, let me know, I'm from Trinidad & Tobago :)
     
As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/1086143

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice