Hi there,
I have an index match match 2-way look up, which returns data based on another tab. (The index match does a vertical look up and then a horizontal one). The formula works fine, but I would like to introduce a variable into the formula to so it looks up the 'correct' tab, corresponding with the value in column A. I'm not familiar with the Indirect formula, but have tried giving this a go with no success. Is this possible?
The formula needs to allow for the fact that I may have up to 20 or so receiving IDs/ tabs. The range for all tabs will the same, albeit the detail contained within the tabs will be different. Ordinarily, I would just use an IF statement, e.g. IF ABC, then look up the ABC tab, etc but this doesn't feel very efficient in instances where there will be multiple scenarios.
I have attached an image which shows the formula in red, where ideally I would like this to look up tab "CDE" automatically.
Many thanks - appreciate any help in advance!
I have an index match match 2-way look up, which returns data based on another tab. (The index match does a vertical look up and then a horizontal one). The formula works fine, but I would like to introduce a variable into the formula to so it looks up the 'correct' tab, corresponding with the value in column A. I'm not familiar with the Indirect formula, but have tried giving this a go with no success. Is this possible?
The formula needs to allow for the fact that I may have up to 20 or so receiving IDs/ tabs. The range for all tabs will the same, albeit the detail contained within the tabs will be different. Ordinarily, I would just use an IF statement, e.g. IF ABC, then look up the ABC tab, etc but this doesn't feel very efficient in instances where there will be multiple scenarios.
I have attached an image which shows the formula in red, where ideally I would like this to look up tab "CDE" automatically.
Many thanks - appreciate any help in advance!
