Indirect

[wildturkey]

Really do struggle with this

I have this formula which equals 21

=MATCH(Table11[[#Headers],[CTZ3]],Overseas!$A:$A,0)

I need the 21 in the following to be replaced by the first formula

=SUMIF(Overseas!$4:$4,[@[Week Commencing]],Overseas!$21:$21)

I guess it's INDIRECT but that's where my brain stops...

 

[Aladin Akyurek]

Try:

=SUMIF(Overseas!$4:$4,[@[Week Commencing]],INDEX(Overseas!$1:$1048576,MATCH(Table11[[#Headers],[CTZ3]],Overseas!$A:$A,0),0))