View Single Post
 
Old 03-26-2020, 02:19 AM
greatinfoteam greatinfoteam is offline Windows 8 Office 2016
Novice
 
Join Date: Mar 2020
Posts: 4
greatinfoteam is on a distinguished road
Exclamation INDEX/MATCH that work on Master Sheet to collect data from 12 sheets

Hey all Excel experts
Someone told me to post my question as a New Thread so i am posting my problem here again with all details

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, 7 views)
Reply With Quote