+ Reply to Thread
Results 1 to 5 of 5

Need to use partial text to lookup data in worksheet using a text box or combo box or both

  1. #1
    Registered User
    Join Date
    03-07-2017
    Location
    Stockport, England
    MS-Off Ver
    2007
    Posts
    90

    Need to use partial text to lookup data in worksheet using a text box or combo box or both

    Hi Guys,

    I need to be able to search for partial text in definable columns in a worksheet, using a user form textbox or combo box. I have attached what I have already but I can only get it to work if the exact match is found. Please help, thanks!
    Attached Files Attached Files

  2. #2
    Forum Expert dangelor's Avatar
    Join Date
    09-06-2011
    Location
    Indiana, USA
    MS-Off Ver
    365 Pro Plus
    Posts
    2,255

    Re: Need to use partial text to lookup data in worksheet using a text box or combo box or

    Possibly the look up variable to include wildcard characters...
    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    03-07-2017
    Location
    Stockport, England
    MS-Off Ver
    2007
    Posts
    90

    Re: Need to use partial text to lookup data in worksheet using a text box or combo box or

    I'll give that a go thanks dangelor.

  4. #4
    Registered User
    Join Date
    03-07-2017
    Location
    Stockport, England
    MS-Off Ver
    2007
    Posts
    90

    Re: Need to use partial text to lookup data in worksheet using a text box or combo box or

    That has worked, Thank you dangelor, Much appreciated!!!

  5. #5
    Forum Expert dangelor's Avatar
    Join Date
    09-06-2011
    Location
    Indiana, USA
    MS-Off Ver
    365 Pro Plus
    Posts
    2,255

    Re: Need to use partial text to lookup data in worksheet using a text box or combo box or

    Happy to help!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] How to lookup a partial text string
    By joh_ver in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 12-09-2016, 04:47 PM
  2. Partial lookup from text string, return value from lookup list
    By TotallyLost in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 06-13-2016, 12:14 PM
  3. Partial Text String Lookup from a List
    By lookingforhelp1 in forum Excel General
    Replies: 5
    Last Post: 01-14-2016, 09:15 AM
  4. [SOLVED] Lookup with partial text match
    By teekey in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-17-2014, 03:47 PM
  5. Lookup partial value and return text I define
    By Venessa in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-11-2013, 11:21 AM
  6. [SOLVED] Partial text lookup
    By Maartenvds89 in forum Excel General
    Replies: 6
    Last Post: 07-13-2012, 05:45 AM

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