Formula Issue
I think you mean that as August is the 8th month then you want the 8th
cell from the range D5:D16. Is that correct?
Pete
On Sep 3, 12:19*am, Steved wrote:
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
|