Hi, I am trying to use index match to match data from multiple sheets onto one master sheet. the master sheet is a list of names for participants in a program. the multiple sheets i want to match are participants' gender from each year (2010,2011,2012,2013,2014).
i can get it to work matching the 2010 sheet to the master sheet, using this:
=INDEX('2010'!$J$2:$J$1454,MATCH(A2,'2010'!$A$2:$A$1454,0))
i would appreciate any help adding in the other sheets!! thank you!
Hi, welcome to the forum
Do you mean you want to be able to select the sheet from info on the master, or do you want to look on all sheets for info to bring back to the master?
for the 1st option, you could probably use INDIRECT() in te INDEX/MATCH, for the 2nd, maybe some nesting.
However, I suggest that you upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
HI, thank you! I mean I want to look an all sheets for info to bring back to the master. I am new to excel so I don't know how to use nesting, could you help me out with how to do that?
upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks