Thread: INDEX/MATCH that work on Master Sheet to collect data from 12 sheets
View Single Post
 
Old 03-25-2020, 11:56 PM
greatinfoteam greatinfoteam is offline Windows 8 Office 2016
Novice
  
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