Capital letters in formula

[lukasz_rz]

Dear Experts.

I Have a table (example):
column AD column AE
CAT CT
dog DG
elephant EL

Then, I have a column (O2) where I try to find strings from the above (CAT, dog, elephant) and display those as CT,DG,EL in a new column.

INDEX(Lists!AE:AE;AGGREGATE(15;6;ROW(Lists!$AE$2:$AE$7)/(COUNTIF(O2;Lists!$AD$2:$AD$7)>0);1)

But, the formula displays CT for any of these: CAT, cat, Cat, etc. What I need is to display CT only when CAT string is found, is that possible?

Will appreciate your help, thanks.

 

[lukasz_rz]

This approach doesn't want the wildcards so the "*" are stripped:

Works exactly as I needed, thanks!