D
Dave F
SUM('GDCS Budget'!$E$8:ADDRESS(8,INDEX(MATCH(AO5,E5
5,0),,)+4))-'GDCS
Act_FCST'!AK8
5,0),,)+4))-'GDCSAct_FCST'!AK8
D
Dave F
SUM('GDCS Budget'!$E$8:ADDRESS(8,INDEX(MATCH(AO5,E5
Act_FCST'!AK8
Sorry, posted this before I asked the question.
The formula '=ADDRESS(8,INDEX(MATCH(AO5,E5
5,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,E5
5,0),,)+4))-'GDCS Act_FCST'!AK8
I get an error.
Thoughts?
M
Marcelo
Address return a text string, use Indirect(address(...
hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo
"Dave F" escreveu:
hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo
"Dave F" escreveu: