Results 1 to 16 of 16

Help creating search box

Threaded View

  1. #1
    Forum Contributor
    Join Date
    04-30-2009
    Location
    USA
    MS-Off Ver
    Excel 2016
    Posts
    496

    Help creating search box

    Hello all. I am using http://www.excel-easy.com/examples/search-box.html as a reference and I almost have it figured out...but not quite. In the attached file, I want the matching names from column "A" to be displayed in column "E" where the following formula resides:
    =IFERROR(VLOOKUP(D4,$A$4:$C$500,-3,FALSE),"")
    I used -3 thinking the column being referenced was the one I wanted to use to get the matched results. Any help is appreciated.

    Andrew
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Creating a search box
    By 8dk5 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-26-2015, 04:24 PM
  2. [SOLVED] Creating a search
    By Aza3000 in forum Excel General
    Replies: 3
    Last Post: 08-20-2015, 09:26 AM
  3. Replies: 4
    Last Post: 05-20-2014, 10:03 AM
  4. [SOLVED] Creating a search bar using VBA
    By Steve_123 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-29-2014, 07:46 AM
  5. Creating search box in cell - Currently using Macro 'Range to search' *HELP*
    By jacko058 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-14-2014, 05:24 AM
  6. Replies: 0
    Last Post: 03-05-2009, 01:43 PM
  7. Creating Search Bar
    By kiany406 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-28-2007, 03:21 PM

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