Formula not working - what is wrong?

[Camel123]

Hi,

I want to modify this formula (currently working):
=IF(D5="";"";IF(K5="cancelled";"Cancelled";IF(AND(ISNA(VLOOKUP(D5;'Sammanst 1904'!$F:$F;1;FALSE));B5<>"");"Plan now (!)";IF(ISNA(VLOOKUP(D5;'201904'!$F:$F;1;FALSE));"Plan";"Included"))))

I added the red string below but it is not working. If the specified text + wildcard is in cell J4 i want it to run the rest of the functions, if not, I want it to return "Period not specified" (not sure where to place this in the formula string).


=IF(D4="";"";IF(K4="cancelled";"Cancelled";IF(--(SEARCH({jan;feb;mar;apr;maj;may;jun;jul;aug;sep;okt;oct;nov;dec}&"*";J4)>0;IF(AND(ISNA(VLOOKUP(D4;'Sammanst 1904'!$F:$F;1;FALSE));B4<>"");"Plan now (!)";IF(ISNA(VLOOKUP(D4;'Sammanst 1904'!$F:$F;1;FALSE));"Plan";"Included"))))))

Any suggestions?

 

[Special-K99]

Months need to be in quotes at least

 

[Camel123]

Months need to be in quotes at least

Still not working :/