#1
|
|||
|
|||
INDEX/MATCH that work on Master Sheet to collect data from 12 sheets
Hey all Excel experts
I am working with 12 sheets and then have Master sheet. By defining these 12 sheets to a name range, I am able to do it with a formula that only look in 1st sheet and not working for the remaining sheets. to understand my problem please see the attached file. |
#2
|
||||
|
||||
Cross posted at excelforum
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
Tags |
index, indirect, match |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Help Needed With Index/Match To Compare And Pull Data From One Sheet To Another | robertjohn81 | Excel | 1 | 01-19-2017 11:20 AM |
Using If function in VBA to match data from two sheets | cinstanl | Excel Programming | 1 | 12-06-2016 10:37 AM |
Complex calculation from multiple sheets to master sheet | inreality01 | Excel | 49 | 01-06-2016 03:09 PM |
Excel, transfer data from Master Sheet to sub sheets, using key word from column | anvqui | Excel Programming | 9 | 06-16-2015 01:35 PM |
If two geographical data match in two sheets, copy unique id/code found in one sheet | alliage | Excel | 1 | 09-01-2011 05:23 AM |