Results 1 to 6 of 6

Find exact match

Threaded View

  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