Forum Discussion

c_d_miller's avatar
c_d_miller
Copper Contributor
Aug 18, 2024

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('Day (1)'!O$36),'Day (1)'!O$36,""),"")

My question is, what formula can I use to change the 'Day (1)' to 'Day (2)', 'Day (9)' and so on.

 

Any help would be greatly appreciated.

 

Formulas and Functions
  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Platinum Contributor
    Aug 18, 2024

    c_d_miller Try something like this:

    =IF(AND($D5="Drive",ISNUMBER(INDIRECT("'" & A1 & "'!O$36"))),INDIRECT("'" & A1 & "'!O$36"),"")

     

    • c_d_miller's avatar
      c_d_miller
      Copper Contributor
      Aug 18, 2024
      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"),"")

Resources