Using Wildcards

[Jill]

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

[Aflatoon]

You can use SEARCH:

=IF(ISNUMBER(SEARCH("Diamond_Round",E48)),INDEX(RBC!D2:D94,MATCH(I48,RBC!B2:RBC!B96,1)),"")

[Jill]

Thanks Aflatoon! That worked.

This forum and the people on it are amazing.

Jill

[Aflatoon]

You're welcome. :)

[mdmackillop]

Please remember to mark your threads as Solved.