Forum Discussion
Exact text search in a range of cells
Hi, all. I have a search textbox macro for cell B1, which checks a range of cells in sheet 2, and returns any cells which include the search term. Sheet 2 has a number of paragraphs in the range ...
=IF(LEN(B1)=0,"Product Search",FILTER(D1:G5,EXACT(B1,D1:D5)+EXACT(B1,E1:E5)+EXACT(B1,F1:F5)+EXACT(B1,G1:G5)))Does this return your expected result?