I have a formula combining IF with COUNTIFS for multiple ranges and it works smoothly but to check for one sheet only like this =IF(COUNTIFS(District1!B:B,"="&$D5,District1!C:C,"="&$E5),District1!$B$2,"")
to check (IF B:B in sheet District1 = D5 and if C:C in sheet District1 = E5 , so to return Cell $B$2 in district1 sheet otherwise keep it empty)
till now it's ok and the formula works good but I need to repeat it several times to check in other sheets and when i make it like this: =IF(COUNTIFS(District1!B:B,"="&$D5,District1!C:C,"="&$E5),District1!$B$2),IF(COUNTIFS('Carnell'!B:B,"="&$D5,'Carnell'!C:C,"="&$E5),'Carnell'!$B$2),IF(COUNTIFS(Ivory!B:B,"="&$D5,Ivory!C:C,"="&$E5),Ivory!$B$2)))),"") excel doesnt accept it as a formula while i need to repeat it 7 times to check 7 sheets
please let me know how it should have to be ??
thank you in advance
to check (IF B:B in sheet District1 = D5 and if C:C in sheet District1 = E5 , so to return Cell $B$2 in district1 sheet otherwise keep it empty)
till now it's ok and the formula works good but I need to repeat it several times to check in other sheets and when i make it like this: =IF(COUNTIFS(District1!B:B,"="&$D5,District1!C:C,"="&$E5),District1!$B$2),IF(COUNTIFS('Carnell'!B:B,"="&$D5,'Carnell'!C:C,"="&$E5),'Carnell'!$B$2),IF(COUNTIFS(Ivory!B:B,"="&$D5,Ivory!C:C,"="&$E5),Ivory!$B$2)))),"") excel doesnt accept it as a formula while i need to repeat it 7 times to check 7 sheets
please let me know how it should have to be ??
thank you in advance