Hi all,
To begin with I have got exactly 27 sheets with me. I need to run index and match formula on my other workbook that searches through all these 27 sheets before it could return me my matched value.
However I am trying to avoid a huge formula that will match all of these 27 sheets/tables.
I have instead put a helper column on the other workbook that will consist of the sheet's name where the index and match should look up the value. hence avoiding all but 1 sheet of these 27 sheets. also this will shorten the formula I suppose.
So I need a formula that can achieve this kind of index and match if possible at all.
So suppose column A comprises the sheet name (alpha) . and column B is the value (peter) to match and column C is where the index and match formula will got to be.
Any help will be appreciated.
Thank u all.
To begin with I have got exactly 27 sheets with me. I need to run index and match formula on my other workbook that searches through all these 27 sheets before it could return me my matched value.
However I am trying to avoid a huge formula that will match all of these 27 sheets/tables.
I have instead put a helper column on the other workbook that will consist of the sheet's name where the index and match should look up the value. hence avoiding all but 1 sheet of these 27 sheets. also this will shorten the formula I suppose.
So I need a formula that can achieve this kind of index and match if possible at all.
So suppose column A comprises the sheet name (alpha) . and column B is the value (peter) to match and column C is where the index and match formula will got to be.
Any help will be appreciated.
Thank u all.