Tab Reference

[JoeExcelHelp]

Can you guys assist with modifying this formula to reference a cell where is says "Year2014" Id like the flexibility to change the tab reference within another workbook by simply changing the cell value

Code: Select all

=IFERROR(VLOOKUP($B35&$G$4&I$32,'H:\2014 SSR\Test R18\[2014 Schedule EQ and Dep.xls]Year2014'!$A$1:$AO$65536,37,FALSE),"-")

[HansV]

In theory, the INDIRECT function can be used for this, but it only works if the workbook referred to is also open in (the same instance of) Excel.

So if you want to refer to different sheets in another open workbook, INDIRECT will work. But if you want to refer to different workbooks, it won't.