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
Click to expand...
 

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

Similar Threads

Cumulative formula for word table 0
How to get the following data ... How to create the formula for below 1
Counting Cells With Multiple Criteria on Multiple Sheets 0
Counting Cells With Multiple Criteria on Multiple Sheets 0
How to reflect month to entered Data 0
(Advanced Excel) Figuring out a formula of continuous progressiontrying to create 19 Formulas into O 5
COUNTIF + ADDRESS Issue 1
Subtracting 37 hours from a cell containing format [h]:mm 2

Top