Hi guys,
I have a sumif formula that I'm trying to link to dynamic tab names based on a drop down. I'm fairly new to indirects, but got the function to work with explicit sheet names. However, when I throw in a vlookup to build a dynamic sheet name it breaks. Any help is appreciated.
Here's the formula that isn't working, it returns #Ref ! The Vlookup is looking for the first part of the sheet name, and the second part is constant. I've removed the latter part of the formula as it hasn't changed from the working version.
[TABLE="width: 130"]
<colgroup><col></colgroup><tbody>[TR]
[TD]=SUMIFS(INDIRECT("'"&VLOOKUP($B$1,$S$3:$T$13,2,FALSE)&" Second Part of Sheet Name'"&"!"&"$C$98&:$&NC$98")[/TD]
[/TR]
</tbody>[/TABLE]
I have a sumif formula that I'm trying to link to dynamic tab names based on a drop down. I'm fairly new to indirects, but got the function to work with explicit sheet names. However, when I throw in a vlookup to build a dynamic sheet name it breaks. Any help is appreciated.
Here's the formula that isn't working, it returns #Ref ! The Vlookup is looking for the first part of the sheet name, and the second part is constant. I've removed the latter part of the formula as it hasn't changed from the working version.
[TABLE="width: 130"]
<colgroup><col></colgroup><tbody>[TR]
[TD]=SUMIFS(INDIRECT("'"&VLOOKUP($B$1,$S$3:$T$13,2,FALSE)&" Second Part of Sheet Name'"&"!"&"$C$98&:$&NC$98")[/TD]
[/TR]
</tbody>[/TABLE]