This will give you a True if any value in the OTHER-LIST is found in the RANGE-TO-BE-SEARCHED (i.e. the 2 columns): =SUM(COUNTIF(RANGE-TO-BE-SEARCHED,OTHER-LIST))>0 But is that really all you want? just a True/False? Or are you trying to find out WHICH values in the list are in the columns or trying to get a UNIQUE list combining both regions? or something else?