Nested IF Statement taking too long

[Toza]

I'm currently using the below if statement to find cells with column AC that contain MISY2L, CNFM2L or SBOS3Q. The formula itself works fine but when it autofills (about 10,000 lines) excel is taking about 10 mins to caluate the values.

Range("AI2").Formula = "=IF(ISNUMBER(SEARCH(""*MISY2L*"",AC2)),""ETC"",IF(ISNUMBER(SEARCH(""*CNFM2L*"",AC2)),""ETC"",IF(ISNUMBER(SEARCH(""*SBOS3Q*"",AC2)),""ETC"","""")))"
Range("AG2:AI2").AutoFill Destination:=Range("AG2:AI" & Cells(Rows.Count, "AC").End(xlUp).Row)

Is there a more efficient way to achieve the same outcome?

Thanks
Torin

 

[Jonmo1]

Welcome to the board..

Here's one way.
This is how it appears in the cell, I'll leave it to you to translate into your Code.

=IF(ISNUMBER(LOOKUP(2^15,SEARCH({"MISY2L";"CNFM2L";"SBOS3Q"},AC2))),"ETC","")

 

[Toza]

That worked perfectly!

Thanks