Results 1 to 6 of 6

Find exact match

Threaded View

indimonk Find exact match 01-21-2012, 12:16 AM
JapanDave Re: Find exact match 01-21-2012, 12:47 AM
indimonk Re: Find exact match 01-21-2012, 01:24 AM
JapanDave Re: Find exact match 01-21-2012, 01:31 AM
royUK Re: Find exact match 01-21-2012, 04:04 AM
indimonk Re: Find exact match 01-30-2012, 11:25 PM
  1. #1
    Registered User
    Join Date
    11-09-2011
    Location
    bombay
    MS-Off Ver
    Excel 2003
    Posts
    10

    Find exact match

    I want to check whether a text in a cell is available in a range.

    For instance, if I search for A*B in the following range

    B*C
    A*B*C
    D*E
    F*C

    it should return me false and should not consider A*B*C.
    I used Find method with lookAt:= xlWhole but is not working. Is there any other alternative that would find the exact match?
    Last edited by indimonk; 01-30-2012 at 11:26 PM.

Thread Information

Users Browsing this Thread

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

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