Look-up

%3CLINGO-SUB%20id%3D%22lingo-sub-1588114%22%20slang%3D%22en-US%22%3ELook-up%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1588114%22%20slang%3D%22en-US%22%3ENewbie%20question-%20I%20need%20to%20search%202%20columns%20in%20a%20worksheet%20(containing%20text)%20to%20determine%20if%20any%20values%20in%20another%20list%20can%20be%20found%20in%20the%202%20text%20columns.%20How%20do%20I%20do%20this%3F%3CBR%20%2F%3EThanks%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1588114%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Occasional Visitor
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
Highlighted
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?