Trying to dynamically get cell value from worksheet in same workbook, depending on worksheet name in column E =IF(E108<>"",INDIRECT(CELL("contents", E108)
I have a workbook - lets call it Book1 Book1 contains 5 worksheets; Sheet1, Sheet1A, Sheet2, Sheet2A, Summary Within the Summary worksheet there is a table whic