|
|
#1
03-25-2020, 11:56 PM
|
|||
|
|||
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
03-26-2020, 12:54 AM
|
||||
|
||||
|
Cross posted at excelforum
__________________
Using O365 v2503 - 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 |
| Thread Tools | |
| Display Modes | |
|
|
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 |
Windows 8 
Office 2016
Linear Mode
