Hello from Steve

The below returns the value in D5 the value I require is in D12

{=IF($E$106="Aug",'Trips per Calendar Year'!$D$5:$D$16,0)}

my attempt below returns a "0" value.

{=IF($E$106=$A$5:$A$16,'Trips per Calendar Year'!$D$5:$D$16,0)}

Thankyou