+ Reply to Thread
Results 1 to 3 of 3

Wildcard string

  1. 11-22-2005, 11:16 AM #1
    Robo
    Robo is offline
    Registered User
    Join Date
    07-21-2004
    Posts
    66

    Wildcard string

    Can I use vlookup to find a wildcard text string

    ie =vlookup(*a2*,data_range,2,false)

    If not vlookup, is there an alternative?

    Thanks

    Robo
    Reply With QuoteRegister To Reply
  2. 11-22-2005, 11:20 AM #2
    mdbct
    mdbct is offline
    Valued Forum Contributor mdbct's Avatar
    Join Date
    11-11-2005
    Location
    CT
    MS-Off Ver
    2003 & 2007
    Posts
    848
    You ned to concatenate your *s to the cell reference. Your formula would be:
    =vlookup("*"& A2 & "*", data_range,2,false)
    Reply With QuoteRegister To Reply
  3. 11-22-2005, 11:26 AM #3
    Robo
    Robo is offline
    Registered User
    Join Date
    07-21-2004
    Posts
    66
    Thanks very much!!

    Robo
    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)

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