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.
Bookmarks