Look-up

Copper Contributor
Newbie question- I need to search 2 columns in a worksheet (containing text) to determine if any values in another list can be found in the 2 text columns. How do I do this?
Thanks
1 Reply
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?