=ADDRESS(8,INDEX(MATCH(AO5,E5:P5,0),,)+4)

[Dave F]

SUM('GDCS Budget'!$E$8:ADDRESS(8,INDEX(MATCH(AO5,E55,0),,)+4))-'GDCS
Act_FCST'!AK8

 

[Dave F]

SUM('GDCS Budget'!$E$8:ADDRESS(8,INDEX(MATCH(AO5,E55,0),,)+4))-'GDCS
Act_FCST'!AK8

Sorry, posted this before I asked the question.

The formula '=ADDRESS(8,INDEX(MATCH(AO5,E55,0),,)+4) returns $P$8.

When I try to insert it into my large formula, like this: SUM('GDCS
Budget'!$E$8:ADDRESS(8,INDEX(MATCH(AO5,E55,0),,)+4))-'GDCS Act_FCST'!
AK8

I get an error.

Thoughts?

 

[Marcelo]

Address return a text string, use Indirect(address(...

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Dave F" escreveu: