Use cell value as the table array in vlookup.

[jtedmonson42]

So my vlookup is =IFERROR(VLOOKUP(C24,'xyz1'!B:AL,19,FALSE),"")

So I have a tab/source named xyz1. I have a cell, D1, on my main sheet where this formula is that is just =Pivot!B1 get the value of one of the filters in this case xyz1. So the cell D1 changes when i change the filters to abc1 etc etc. But when I'm changing the filters I'm also changing the data source of the table to a sheet that matches the name of the filter so xyz1 is a source tab and so is abc1.

What I want do is replace the the 'xyz1' in the formula with the value in cell D1, so that when I change the filter value on the pivot and D1 changes the lookup in the formula changes as well, so I don't have to change the formula each time I change sources.

 

[DRSteele]

If you have xyz1 (or abc1, or whatever) in cell D1, substitute the expression 'xyz1'!B:AL in your formula with this: INDIRECT(D1&"!B:AL")