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 of cells.
The search works, but how do I make it an
exact search (not case-sensitive), for what is typed in B1.
Eg.
If someone types
HR in B1, only cells which include an exact match are returned, and not any words (eg
threat) which include the search term
HR.
If someone types
Perform in B1, only cells which include an exact match are returned, and not any words (eg
performance) which include the search term perform.
This is the formula for the search so far:
=IF((LEN(B1))=0, "Product Search", FILTER('Product List'!A2:F152,ISNUMBER(SEARCH(B1,'Product List'!A2:A152))+ISNUMBER(SEARCH(B1,'Product List'!B2:B152))+ISNUMBER(SEARCH(B1,'Product List'!C2:C152))+ISNUMBER(SEARCH(B1, 'Product List'!D2
152))+ISNUMBER(SEARCH(B1, 'Product List'!E2:E152))+ISNUMBER(SEARCH(B1, 'Product List'!F2:F152)),"No records found"))
Thanks