Search Box + YES/NO Output

[Garzzza]

Hello Everyone, I need to make my Search Box a bit smarter than it is, I guess there is a solution for this since I have found some functions that by themsleves do part of what I need.

Please look at the Screenshot (Sample workbook attached as well):

• I need to Input a value/string into the Search Box in/over C2
• If the value/string is found in Colum A, then please give the output "OUT", in colum B, if not just stay at "?".
• This output should stay at "OUT" though...because I will input other value/string in the search box.

Excel.jpg

I would be extremely grateful for some help here.

Thanks a lot and regards,

G

[AliGW]

Welcome to the forum.

There are instructions at the top of the page explaining how to attach your sample workbook (not a screenshot of it).

A good sample workbook has just 10-20 rows of representative data that has been desensitised. It also has expected results mocked up, relevant cells highlighted and a few explanatory notes.

[Garzzza]

Hello. Thanks. I edited my post and attached my sample workbook.

Also, im indeferent on wheter the solution is with formulas or VBA. Any soultion is welcomed

[sintek]

No need for a TextBox
Code in Sheet Module...

Please Login or Register  to view this content.

[Garzzza]

Thank you very very much. I will check it out in Detail and see if I can replicate it under different conditions.

[sintek]

replicate it under different conditions.

You mean other condition not as per sample file requirement?

[Garzzza]

Ok I did it. No sorry, I meant, my original table is much bigger and complex than the sample one. So I needed to change/adapt your code to that. But it worked perfectly, so thanks a lot.

[sintek]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
Glad to have helped...Tx for rep +