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, 6 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,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

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

All times are GMT -7. The time now is 10:54 AM.


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