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