Reference Cell Altering Formulas

  • Thread starter Thread starter joshuadennin
  • Start date Start date
J

joshuadennin

=INDIRECT("'"&A4&"'!"&"E"&(5+((Lineup!$H$2-1)*13)))

When the reference cell 'Lineup!$H$2* is changed, the entire formula is changes.

For example, if the reference cell started at value = 1 and is changed tovalue = 3, the formula is changed to =INDIRECT("'"&A4&"'!"&"E"&(8+((Lineup!$H$2-1)*13))). The position of the formula within the spreadsheet stays the same, but for some reason the +5 is changed to a +8.

What gives?

Thanks,

Josh
 
=INDIRECT("'"&A4&"'!"&"E"&(5+((Lineup!$H$2-1)*13))) When the reference cell 'Lineup!$H$2* is changed, the entire formula is changes. For example, if the reference cell started at value = 1 and is changed to value = 3,the formula is changed to =INDIRECT("'"&A4&"'!"&"E"&(8+((Lineup!$H$2-1)*13))). The position of the formula within the spreadsheet stays the same, but for some reason the +5 is changed to a +8. What gives? Thanks, Josh
Click to expand...
 
Back
Top