needhelpbad23
New Member
- Joined
- Jan 29, 2021
- Messages
- 4
- Office Version
- 2010
- Platform
- Windows
I have a formula issue. I want to return three possible options First, Second or Other. This is what I have so far =IF(ISNUMBER(SEARCH("*1st Lien*", '[Book3] Column Name'!C10), "Second Lien", IF(ISNUMBER(SEARCH("*2nd Lien*", '[Book3] Column Name'!C10), "Second Lien", IF(ISNUMBER(SEARCH("*S*", '[Book3] Column Name'!C10), "Other", '''')