Search changed to be Case Sensitive

[Dean Thatcher]

How can this be changed to be case sensitive. $L$6:$R$6 is where the search data is entered.

Would like to search for W or w, CHECK or check. the results would be all words that have a w or W, or CHECK OR check or Check in them

{=INDEX($B$9:$H$538, SMALL(IF(MMULT(ISNUMBER(SEARCH($L$6:$R$6, $B$9:$H$538))*($L$6:$R$6<>""), {1;1;1;1;1;1;1})=COUNTA($L$6:$R$6), MATCH(ROW($B$9:$B$538), ROW($B$9:$B$538)), ""), ROWS($A$1:A1)), COLUMNS($A$1:A1))}

 

[Hui]

Dean

Search is Case Insensitive

If you need to be case sensitive use the Find() function instead

 

[Dean Thatcher]

Dean

Search is Case Insensitive

If you need to be case sensitive use the Find() function instead

Hui Thanks for the replay. I am tring this out.
Maybe you can help me with this Sheet. I would like to add 3 more Columns. Col 8, Col 9 and Col 10.
and have them search like Cust name. and show results.
Thanks for you help.

 

[Dean Thatcher]

Hui Thanks for the replay. I am tring this out.
Maybe you can help me with this Sheet. I would like to add 3 more Columns. Col 8, Col 9 and Col 10.
and have them search like Cust name. and show results.
Thanks for you help.

I added the Data to Col 8, Col 9, Col 10.

 

[Hui]

Use an advanced Filter
with settings as


Result is


Note the Two Appt Date fileds in the Criteria Range

 

[Dean Thatcher]

Use an advanced Filter
with settings as
View attachment 67014

Result is
View attachment 67013

Note the Two Appt Date fileds in the Criteria Range

Sorry but i don't under stand why you picked appt date? can you attach your file so i can try it?
thanks