-
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
-
You can use SEARCH:
=IF(ISNUMBER(SEARCH("Diamond_Round",E48)),INDEX(RBC!D2:D94,MATCH(I48,RBC!B2:RBC!B96,1)),"")
-
Thanks Aflatoon! That worked.
This forum and the people on it are amazing.
Jill
-
You're welcome.
-
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
-
Forum Rules