Im having trouble getting a cell to populate based on the first part of an account code. Ive been using nested if functions but that isnt working. right now i have this:
=IF(ISNUMBER(SEARCH("123456",G36)),"Advertising"
I then just continue adding each expense account into the function.
This works, but i cant get all of my expense accounts into the formula because it says i use more levels of nesting than i can use in the current file format. I tried just regular IF functions but the last 3 digits of the expense code change based on the vendor to which it is assigned.
Is there a way i can change the file format to make it all fit?
Or
Is there a better function that i can use
Bookmarks