Formula help =if(COUNTIF....

Hello,

I have a working formula to show the text Match when a matching table cell is compared to a cell in a range.

The working formula is

Please Login or Register  to view this content.

I am hoping to check multiple ranges against the same 'All units'!A3 table cell. Can someone please advise me on the best formula for this...

I have tried something like this

Please Login or Register  to view this content.

but get a #Value error

Any help is much appreciated!

Try this ...

=IF(COUNTIF(MEM30305!$B$2:$B$33,'All units'!A3)+COUNTIF(MEM30305!$H$3:$H$44,'All units'!A3),"Match","")

Perhaps

=IF(COUNTIFS('MEM40105'!$B$2:$B$42,'All units'!A3,'MEM40105'!$H$3:$H$44,'All units'!A3)>0,"Match","")

Thanks all Cheers!