=HL12-HL2 (make it so that if I enter 10 in a box it takes hl12 and finds hl2?

[soundengineer]

i dont know any better way to explain it..
right now all the formulas have a 10 spacing..(12-10=2)
=HL12-HL2
but I want to make it so that if I want to do it by 6 then I can just put 6 in a cell and it will automatically change the formula to
=HL12-HL6
a six spacing (12-6=6)
or any other value for that matter..

[Bryan Hessey]

i dont know any better way to explain it..
right now all the formulas have a 10 spacing..(12-10=2)
=HL12-HL2
but I want to make it so that if I want to do it by 6 then I can just put 6 in a cell and it will automatically change the formula to
=HL12-HL6
a six spacing (12-6=6)
or any other value for that matter..

Hi,

try

=Indirect("HL12-HL"&A1)

with 6 etc in A1

---

[soundengineer]

all I get is a #REF error

and when I look up in the help file that would be the same as saying HL12-HL6
but if I have 10 in there then its HL12-HL10 which is not what I need
IF I put in 10 then it needs to be 12-10=2 for HL2
next cell would be 13-10=3 or HL3

[soundengineer]

all I get is a #REF error

and when I look up in the help file that would be the same as saying HL12-HL6
but if I have 10 in there then its HL12-HL10 which is not what I need
IF I put in 10 then it needs to be 12-10=2 for HL2
next cell would be 13-10=3 or HL3

ok...I got it to make sense and work the way I needed it
took this

=HL12-(INDIRECT("HL"&(ROW()-Sheet1!$B$1)))

[Bryan Hessey]

ok...I got it to make sense and work the way I needed it
took this

=HL12-(INDIRECT("HL"&(ROW()-Sheet1!$B$1)))

good to see a resolution, and thanks for the feedback

---