I have an Excel workbook that has several sheets. I need to reference a sheet using a cell that has a number in it, i.e. =IF($D5=”Drive”,IF(ISNUMBER(‘Day (1)’!O$36),’Day (1)’!O$36,””),””), is there a way to change ‘Day (1)’ to ‘Day (2)’ using a cell reference on that sheet i.e $A$1 ????

​I have an Excel workbook that has several sheets. I need to reference a sheet using a cell that has a number in it, i.e. =IF($D5=”Drive”,IF(ISNUMBER(‘Day (1)’!O$36),’Day (1)’!O$36,””),””), is there a way to change ‘Day (1)’ to ‘Day (2)’ using a cell reference on that sheet i.e $A$1 ????  Read More

​