Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-25-2020, 11:56 PM
greatinfoteam greatinfoteam is offline INDEX/MATCH that work on Master Sheet to collect data from 12 sheets Windows 8 INDEX/MATCH that work on Master Sheet to collect data from 12 sheets Office 2016
Novice
INDEX/MATCH that work on Master Sheet to collect data from 12 sheets
 
Join Date: Mar 2020
Posts: 4
greatinfoteam is on a distinguished road
Default 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.
Attached Files
File Type: xlsx example.xlsx (295.6 KB, 2 views)
Reply With Quote
  #2  
Old 03-26-2020, 12:54 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline INDEX/MATCH that work on Master Sheet to collect data from 12 sheets Windows 7 64bit INDEX/MATCH that work on Master Sheet to collect data from 12 sheets Office 2010
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,406
Pecoflyer is a name known to allPecoflyer is a name known to allPecoflyer is a name known to allPecoflyer is a name known to allPecoflyer is a name known to allPecoflyer is a name known to all
Default

Cross posted at excelforum
__________________
Please note I am not active on this forum anymore
Reply With Quote
Reply

Tags
index, indirect, match

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
INDEX/MATCH that work on Master Sheet to collect data from 12 sheets Help Needed With Index/Match To Compare And Pull Data From One Sheet To Another robertjohn81 Excel 1 01-19-2017 11:20 AM
INDEX/MATCH that work on Master Sheet to collect data from 12 sheets 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
INDEX/MATCH that work on Master Sheet to collect data from 12 sheets 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

Other Forums: Access Forums - Senior Forums

All times are GMT -7. The time now is 02:12 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2020, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2020 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft