Nested IF statements with a Search function

**ChesireCat** · 10-02-2018, 11:20 AM

Hello All,

I am hoping that someone can help me with this formula. It seems to breach when I add additional SEARCH functions in a nested IF statement.
When I added the last criteria to find the word "Reclass" I get a #Value Error

YES the source cell is TEXT. I did check it.
YES the word Reclass is in the cell in the sentence: Reclass CAD balance out of 113910

=IF(K61="Cigna Catalyst Pmt","CIGNA CATALYST",IF(K61="","DIRECT DEPOSITS",IF(K61="Adjustment to Month End Cash Balance for Wells Che","FICOBATCH-CM",IF(LEFT(K61,12)="ZBA Transfer","TRANSFER CREDIT",IF(SEARCH("P/R",K61),"ADP",IF(SEARCH("OCI",K61),"OCI",IF(SEARCH("ach 8/18",K61),"US CUSTOMS",IF(SEARCH("Reclass",K61),"NET"))))))))

Maybe there is a better way to Categorize items based on row "K"

THANK YOU!
Rich

**brant.wheeler** · 10-02-2018, 11:39 AM

Try this formula. Multiple searches also give me an error. As an alternative, I used the ISNUMBER(FIND()) combination. Worked great for me. I also, closed the last if statement to return a blank if none of the criterion are met.

Formula:

Please Login or Register  to view this content.

Thanks!

**jeffreybrown** · 10-02-2018, 07:10 PM

Administrative Note:

We would love to continue to help you with your query, but first, before we can proceed…
Please see Forum Rule #8 about cross-posting and adjust accordingly...
Also see, A message to forum cross posters

**ChesireCat** · 10-03-2018, 01:20 PM

Thanks dude! It worked! Ca marche! Merci! Macho grassyass!!!

Nested IF statements with a Search function

LinkBack

Thread Tools

Rate This Thread

Display

Nested IF statements with a Search function

Re: Nested IF statements with a Search function

Re: Nested IF statements with a Search function

Re: Nested IF statements with a Search function

Thread Information

Users Browsing this Thread

Similar Threads

Nested If Function/ Search

[SOLVED] Nested if statements , with the ,IF(ISNUMBER(SEARCH

7 nested IF statements with a SEARCH added IF(ISNUMBER(SEARCH({"INSUR","AP REFUND"}

[SOLVED] simple search function using nested IF and Vlookup statements

Help using the AND function with nested IF statements

function to replace nested if statements with linked tables

Nested IF functions with Search statements

Bookmarks

Bookmarks

Posting Permissions