Hi All,
I am trying to return the value of a range of cells if it meets multiple criteria.
I have got this working on 2 criteria but need to add in a third, and can not get it to work.
{=IFERROR(INDEX('CR Data Entry'!$H$2:$H$1000,MATCH("*Barnwood*", IF('CR Data Entry'!$AL$2:$AL$1000=$D22, 'CR Data Entry'!$P$2:$P$1000,""),0)),"")}
So this finds the value in range 'CR Data Entry'!$H$2:$H$1000 if it meets Barnwood and week commencing($D22).
I now need it to also meet criteria of ">=270" in range 'Change Impact Calculator'!$R$2:$R$1000.
Can anyone please help with this.
Thanks,
Nic.
Bookmarks