Reference Cell Altering Formulas

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
 
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 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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top