Consulting

Results 1 to 5 of 5

Thread: Using Wildcards

  1. #1
    VBAX Regular
    Joined
    Jun 2017
    Posts
    26
    Location

    Using Wildcards

    Im using this formula to find if a cells value is "Diamond_Round"
    =IF(E48="Diamond_Round",INDEX(RBC!D294,MATCH(I48,RBC!B2:RBC!B96,1)),"")

    However, Its possible it could read "old_Diamond_Round" too.

    I've tried using a wildcard and using multiple criteria but i cant seems to get it to work. See below....
    =IF(E48="*Diamond_Round",INDEX(RBC!D294,MATCH(I48,RBC!B2:RBC!B96,1)),"")
    =IF(E44="Diamond_Round",INDEX(RBC!D294,MATCH(I44,RBC!B2:RBC!B96,1)),""), IF(E44="old_Diamond_Round",INDEX(RBC!D294,MATCH(I44,RBC!B2:RBC!B96,1)),"")

    Any ideas what i might be doing wrong?

    Jill

  2. #2
    VBAX Master Aflatoon's Avatar
    Joined
    Sep 2009
    Location
    UK
    Posts
    1,720
    Location
    You can use SEARCH:

    =IF(ISNUMBER(SEARCH("Diamond_Round",E48)),INDEX(RBC!D2:D94,MATCH(I48,RBC!B2:RBC!B96,1)),"")
    Be as you wish to seem

  3. #3
    VBAX Regular
    Joined
    Jun 2017
    Posts
    26
    Location
    Thanks Aflatoon! That worked.

    This forum and the people on it are amazing.

    Jill

  4. #4
    VBAX Master Aflatoon's Avatar
    Joined
    Sep 2009
    Location
    UK
    Posts
    1,720
    Location
    You're welcome.
    Be as you wish to seem

  5. #5
    Administrator
    VP-Knowledge Base
    VBAX Grand Master mdmackillop's Avatar
    Joined
    May 2004
    Location
    Scotland
    Posts
    14,489
    Location
    Please remember to mark your threads as Solved.
    MVP (Excel 2008-2010)

    Post a workbook with sample data and layout if you want a quicker solution.


    To help indent your macros try Smart Indent

    Please remember to mark threads 'Solved'

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •