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