+ Reply to Thread
Results 1 to 4 of 4

Search List and display results

Hybrid View

  1. 10-17-2008, 03:16 AM #1
    morjo
    morjo is offline
    Registered User
    Join Date
    10-17-2008
    Location
    Australia
    Posts
    3

    Search List and display results

    Hi Guys,

    I need to do a search through a list i have and then return any matching results into separate fields or a listbox.

    i.e No. Part Cost
    1 Lamp Round $1.00
    1 Lamp Flat $2.00
    1 Globe Square $3.00
    1 Globe $4.00

    Search Box: ("User Enters - Lamp) even if user types in "La" i want it to find Lamp.

    I need the 2 matching results (Lamp Round and Lamp Flat) to be displayed somewhere.

    Can someone please provide me with info on how to go about doing this please.
    Reply With QuoteRegister To Reply
  2. 10-17-2008, 07:10 AM #2
    davesexcel
    davesexcel is offline
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,523

    Filter data using wildcards

    Here's a couple of examples
    http://www.excelforum.com/attachment...ywildcards.xls
    Attached Files Attached Files
    ,
    Xlorate.com, Selection Codes, YouYube Channel
    Reply With QuoteRegister To Reply
  3. 10-18-2008, 01:36 AM #3
    morjo
    morjo is offline
    Registered User
    Join Date
    10-17-2008
    Location
    Australia
    Posts
    3
    Thats what i need exactly Thanks heaps!!!!
    Reply With QuoteRegister To Reply
  4. 10-18-2008, 02:32 AM #4
    morjo
    morjo is offline
    Registered User
    Join Date
    10-17-2008
    Location
    Australia
    Posts
    3
    One last question please.

    How do i reference the data if it is on another worksheet using that range function?
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Display Number of Occurances from Unique List Against Bulk List
    By Marx in forum Excel General
    Replies: 5
    Last Post: 08-26-2008, 01:07 PM
  2. Data Validation Drop Down List Display
    By laundry125 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 07-28-2008, 01:20 AM
  3. sorting records to display list box options
    By Josh_123456 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-22-2007, 02:17 PM
  4. Dropdown List - Change Display
    By ewainscott in forum Excel General
    Replies: 2
    Last Post: 05-25-2007, 09:49 AM
  5. Display a list without scrolling. (Floating textbox?)
    By BigBas in forum Excel General
    Replies: 2
    Last Post: 05-21-2007, 01:47 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1