I need a formula that will tell me if every item in one column range is somewhere in a second column. The following formula tells me if one item (A100 in this case) is in a column. =SUMPRODUCT(--($A100=$A$10:$A99))>0 I tried to do something like =SUMPRODUCT(--($A150:$A170=$A$10:$A99))>0 but that doesn't work. TIA
Bookmarks