get a range corresponding to a particular col header

  • Thread starter Thread starter PBcorn
  • Start date Start date
P

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

PBcorn said:
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.
Click to expand...
Thanks
Click to expand...
Click to expand...

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