get a range corresponding to a particular col header

[PBcorn]

I have a formula which takes a range argument (technically [array] according
to excel). I want to look up a particular col header and pass a range below
it to the formula. Hence if a new col is added to the referenced table of
data, the formula will always be referencing the correct range. Is this
possible? The formula is quite long so it may be better to use some hidden
rows or something to hold intermediate steps.

Thanks

 

[Gary Brown]

Not sure of your issue, but it kind of sounds like you should check out the
Offset function.
--
Hope this helps.
If this post was helpfull, please remember to click on the ''''YES''''
button at the bottom of the screen.
Thanks,
Gary Brown

 

[Spiky]

Not sure of your issue, but it kind of sounds like you should check out the
Offset function.
--
Hope this helps.
If this post was helpfull, please remember to click on the ''''YES''''
button at the bottom of the screen.
Thanks,
Gary Brown

I have a formula which takes a range argument (technically [array] according
to excel). I want to look up a particular col header and pass a range below
it to the formula. Hence if a new col is added to the referenced table of
data, the formula will always be referencing the correct range. Is this
possible? The formula is quite long so it may be better to use some hidden
rows or something to hold intermediate steps.

Thanks

Or possibly HLOOKUP. Maybe name some of your ranges if you haven't, to
simplify formulas.