I'm getting a #SPILL error on my formula and I'm not sure what I'm doing wrong.
=IF(ISTEXT(SEARCH("Organization",B2)),MID(B2,17,3),IF(ISTEXT(SEARCH({"ELKTON","ORLAND","ROCKYH"},B2)),LEFT(B2,6),A1))
What I want is for the formula to check in cell B2 for the word "organization", and if it contains that word, give me the the specified characters in my MID formula, but if the words ELKTON, ORLAND, or ROCKYH are in B2, then I want it to return the 6 characters on the left. If if doesn't have any of those words/meet those conditions, I want it to return the value in A1. What am I doing wrong?
=IF(ISTEXT(SEARCH("Organization",B2)),MID(B2,17,3),IF(ISTEXT(SEARCH({"ELKTON","ORLAND","ROCKYH"},B2)),LEFT(B2,6),A1))
What I want is for the formula to check in cell B2 for the word "organization", and if it contains that word, give me the the specified characters in my MID formula, but if the words ELKTON, ORLAND, or ROCKYH are in B2, then I want it to return the 6 characters on the left. If if doesn't have any of those words/meet those conditions, I want it to return the value in A1. What am I doing wrong?