Forum Discussion
Formula Question
I need some assistance in figuring out a formula, if it can be done. I need to reference a sheet using a cell that has a number in it, i.e. A1. The current formula is =IF($D5="Drive",IF(ISNUMBER('D...
c_d_miller Try something like this:
=IF(AND($D5="Drive",ISNUMBER(INDIRECT("'" & A1 & "'!O$36"))),INDIRECT("'" & A1 & "'!O$36"),"")
Thanks very much for the info. I did need to make a few changes to the formula you posted in order for it to work properly, and I also did a little reading about that formula. The corrected formula for my needs is: =IF(AND($D5="Drive",ISNUMBER(INDIRECT("'Day (" & A5 & ")'!O$35"))),INDIRECT("'Day (" & A5 & ")'!O$35"),"")