Results 1 to 8 of 8

Search Box + YES/NO Output

Threaded View

  1. #1
    Registered User
    Join Date
    05-02-2022
    Location
    Germany
    MS-Off Ver
    Microsoft® Excel® for Microsoft 365 MSO (Version 2203 Build 16.0.15028.20218) 64-bit
    Posts
    4

    Search Box + YES/NO Output

    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
    Attached Files Attached Files
    Last edited by Garzzza; 05-02-2022 at 06:02 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. VBA - Not getting desired output for SEARCH
    By JosephRajan in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-05-2020, 09:51 PM
  2. Output comes up with #VALUE! when I use OR() and SEARCH()
    By owenmac99 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-15-2018, 11:20 AM
  3. Search data set and output corresponding value
    By freeurmind in forum Excel General
    Replies: 3
    Last Post: 09-16-2013, 03:06 PM
  4. Single Search Output
    By maacmaac in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-23-2009, 09:07 PM
  5. Search for value and output corresponding value
    By bigbeezy in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 02-19-2009, 02:14 AM
  6. [SOLVED] How do I search Strings and get an output?
    By dziw in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-09-2007, 02:26 PM
  7. output a search
    By Skriit in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 11-06-2007, 10:16 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1