INDIRECT filldown problem

[Ryk]

Hope I can get a bit of help on this, we have about 2000 rows and 50 or
so cells in our row that have formulas that have "(INDIRECT(T$1&
"$AB6") in them, as an example. The problem is we'd like to
filldown but the "$AB6" part of it will not change to "$AB7",
"$AB8" as it is pulled down. We need to keep the " " because
it has to reference a cell. Is there a way to do this? I'll example
what we have and what we'd like the next few to become....


=IF(OR(INDIRECT(T$1& "$AB6")="Car parts"),400,0)
=IF(OR(INDIRECT(T$1& "$AB7")="Car parts"),400,0)
=IF(OR(INDIRECT(T$1& "$AB8")="Car parts"),400,0)
=IF(OR(INDIRECT(T$1& "$AB9")="Car parts"),400,0)

Thank you for any help given.

Dave

 

[Franz Verga]

Hope I can get a bit of help on this, we have about 2000 rows and 50
or so cells in our row that have formulas that have "(INDIRECT(T$1&
"$AB6") in them, as an example. The problem is we'd like to
filldown but the "$AB6" part of it will not change to "$AB7",
"$AB8" as it is pulled down. We need to keep the " " because
it has to reference a cell. Is there a way to do this? I'll example
what we have and what we'd like the next few to become....


=IF(OR(INDIRECT(T$1& "$AB6")="Car parts"),400,0)
=IF(OR(INDIRECT(T$1& "$AB7")="Car parts"),400,0)
=IF(OR(INDIRECT(T$1& "$AB8")="Car parts"),400,0)
=IF(OR(INDIRECT(T$1& "$AB9")="Car parts"),400,0)

Thank you for any help given.

Dave

Hi Dave,

I think you have two way:

=IF(OR(INDIRECT(T$1&$AB6)="Car parts"),400,0)

=IF(OR(INDIRECT(T$1&"$AB"&ROW($A6))="Car parts"),400,0)


--
(I'm not sure of names of menus, options and commands, because
translating from the Italian version of Excel...)

Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy

 

[Max]

Instead of this in the start cell:

=IF(OR(INDIRECT(T$1& "$AB6")="Car parts"),400,0)

try this:
=IF(OR(INDIRECT(T$1& "AB"&ROW(A1)+5)="Car parts"),400,0)

When you copy down, it'll increment accordingly
(also removed the unnecess. "$" from the "$AB" part of it)

---