Hi- I have this spreadsheet and depending on the text on column B I want the result "Tax" or "401K" on column C. I used the formulas ISNUMBER and SEARCH and I get the results. However; sometimes there are blank cells in Column B. If that happen I want to get result "401K". How I can do that? I try to combine ISNUMBER and SEARCH formula with ISBLANK but I believe there is something wrong when I am typing the formula because I get the #Value! error. Please see example sheet.
Thank you.
Bookmarks