-
Using Wildcards
Im using this formula to find if a cells value is "Diamond_Round"
=IF(E48="Diamond_Round",INDEX(RBC!D2:D94,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!D2:D94,MATCH(I48,RBC!B2:RBC!B96,1)),"")
=IF(E44="Diamond_Round",INDEX(RBC!D2:D94,MATCH(I44,RBC!B2:RBC!B96,1)),""), IF(E44="old_Diamond_Round",INDEX(RBC!D2:D94,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
-
-
Please remember to mark your threads as Solved.