+ Reply to Thread
Results 1 to 2 of 2

INDEX-MATCH / VLOOKUP - Multiple returns into new cells from selected columns

  1. #1
    Registered User
    Join Date
    04-26-2017
    Location
    England
    MS-Off Ver
    2013
    Posts
    1

    INDEX-MATCH / VLOOKUP - Multiple returns into new cells from selected columns

    Hello, new on here and slowly learning my way through Excel thanks to the university of google.


    I have a master Excel spreadsheet database of over a few thousand jobs covering numerous 'projects'. Each job has a unique serial number and a row of data with twenty columns of specific data attached to it.


    On a separate workbook I have a database for an individual project with it's individual jobs unique serial numbers listed.

    I want to look these jobs up on the master spreadsheet and pull in the values of nine of the twenty associated cells in that row.


    At the moment I have an individual INDEX MATCH formula in each cell, so far I have almost 400 lines of jobs in this individual project. That is a lot of repetitive formulas!

    Is there a way I can look up the unique job serial number in the master spreadsheet and return all nine required values into the next nine cells of my project cell without having to enter a formula into each individual cell of that row?

    Just to complicate matters, the 9 columns of return data are not in sequential order with gaps between the columns that I require returns on so I will need to identify the columns I need.

    Thanks for any help.

  2. #2
    Forum Expert
    Join Date
    11-27-2007
    Location
    New Jersey, USA
    MS-Off Ver
    2013
    Posts
    1,669

    Re: INDEX-MATCH / VLOOKUP - Multiple returns into new cells from selected columns

    You will get help if you attach a sample workbook. Show master spreadsheet data on one sheet and desired result on another sheet. Data could be de-sensitized but in the same format as original.

+ 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. Vlookup/Index&Match Multiple List Returns
    By Lewis825 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-08-2016, 03:11 PM
  2. Sum of multiple Index Match returns!?
    By Spicey_888 in forum Excel General
    Replies: 6
    Last Post: 04-25-2015, 05:30 AM
  3. [SOLVED] Index match or Vlookup multiple columns
    By geliedee in forum Excel General
    Replies: 6
    Last Post: 04-10-2015, 02:14 PM
  4. [SOLVED] index/match or vlookup question over multiple columns
    By lilsnoop in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 03-06-2015, 05:16 PM
  5. VLookup or Index/match searching rows instead of columns or multiple criteria
    By Groovicles in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 11-16-2013, 05:00 PM
  6. [SOLVED] VLOOKUP (or Index/Match) across four columns -- and returning multiple matches
    By rcasey in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-11-2013, 05:20 PM
  7. [SOLVED] vlookup or index-match for multiple columns
    By nmprodan in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-10-2013, 10:48 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