C
cardan
Hello,
I have an issue I can't seem to find an answer to, which I believe is
doable.
I have a worksheet named RU (for Rollup) which pulls information from
3 other worksheets named "RCA","RCB", "RCC" through an Index Match
formula.
I am hoping to insert into the formula the name of the tab I would
like the formula to search from. I would like formula to look for the
name of the worksheet in a cell within the same row, find the
worksheet and then apply the index match formula. That way I can just
the name of worksheet it looks from by changing the value of the cell.
I have tried researching the INDIRECT function but I can't seem to
find an example for what I am trying to do. Any help would be greatly
appreciated. Thank you for your time in advance.
I have an issue I can't seem to find an answer to, which I believe is
doable.
I have a worksheet named RU (for Rollup) which pulls information from
3 other worksheets named "RCA","RCB", "RCC" through an Index Match
formula.
I am hoping to insert into the formula the name of the tab I would
like the formula to search from. I would like formula to look for the
name of the worksheet in a cell within the same row, find the
worksheet and then apply the index match formula. That way I can just
the name of worksheet it looks from by changing the value of the cell.
I have tried researching the INDIRECT function but I can't seem to
find an example for what I am trying to do. Any help would be greatly
appreciated. Thank you for your time in advance.