Filter results based on multiple keywords in a range

[nburaq]

Hi Gents,
I have a table which has a range from A2:A350 in sheet 2 named Table1 @ Specifications column and I would like to filter the results and show them in sheet1 when user enters the keywords in A2 in sheet1. I use this formula in sheet1;
FILTER(Table1[Specifications];ISNUMBER(SEARCH(A2;Table1[Specifications]));"No Result Found")
This formula works perfectly if user enters only one word in cell A2 or sometimes works of user enters multiple words with ** (like *red*table*) however, does not work precisely how excel's CTRL+F function. I can bring more precise results much easier using CTRL+F by *red*table*
So my question is, where do i mistake in my formula? or how can i improve my formula ?
Thanks for any help and comments!

 

[SanjayGMusafir]

Hi Gents,
I have a table which has a range from A2:A350 in sheet 2 named Table1 @ Specifications column and I would like to filter the results and show them in sheet1 when user enters the keywords in A2 in sheet1. I use this formula in sheet1;
FILTER(Table1[Specifications];ISNUMBER(SEARCH(A2;Table1[Specifications]));"No Result Found")
This formula works perfectly if user enters only one word in cell A2 or sometimes works of user enters multiple words with ** (like *red*table*) however, does not work precisely how excel's CTRL+F function. I can bring more precise results much easier using CTRL+F by *red*table*
So my question is, where do i mistake in my formula? or how can i improve my formula ?
Thanks for any help and comments!

What I understand is FILTER function delivers results because Your data in sheet may carry few words between "red" and "table" and Filter function with wildcard simply eliminates them

But with CTRL+F you can only search if "red table" appears in order - System limitations

That's why Wildcards character were introduced in formulae