Results 1 to 7 of 7

how do I allow a VBA search to not look for only exact matches

Threaded View

  1. 10-23-2021, 06:01 AM #1
    Christy_kaye
    Christy_kaye is offline
    Registered User
    Join Date
    10-18-2021
    Location
    Milton Keynes
    MS-Off Ver
    Office 16
    Posts
    8

    how do I allow a VBA search to not look for only exact matches

    hi

    I have this code,
     If ((dataArray(i, *searchField*) = *searchValue*)  Then
    Which is not working. what I am trying to achieve is;
    if all of search value is in any part of search field or vice versa then do X

    Any help?
    Last edited by Christy_kaye; 10-23-2021 at 10:12 AM.
    Reply With QuoteRegister To Reply
« 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. search 2 criteria and if it matches give me the number of matches
    By sxch12 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-14-2017, 03:16 PM
  2. VLOOKUP will not find exact matches, even if the exact same value is in the lookup array
    By hankventure in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-06-2015, 09:15 PM
  3. Comparing data from two columns, looking for similar matches, not exact matches.
    By MKingJr1223 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-15-2014, 09:58 AM
  4. Search two LISTS (columns A and B) to find common matches (which may not be EXACT matches)
    By zonggu in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 08-11-2012, 03:25 PM
  5. Trouble with exact matches!
    By tripvanwinkel in forum Excel General
    Replies: 3
    Last Post: 09-06-2011, 09:10 AM
  6. Finding not exact matches
    By anthonyrambo in forum Excel General
    Replies: 7
    Last Post: 07-08-2011, 03:37 PM
  7. Non exact matches in HLOOKUP
    By scaffdog845 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-27-2009, 11:28 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1