+ Reply to Thread
Results 1 to 5 of 5

Need help filling a cell based on an Account code

  1. #1
    Registered User
    Join Date
    06-04-2019
    Location
    Conway, AR
    MS-Off Ver
    2010
    Posts
    3

    Need help filling a cell based on an Account code

    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

  2. #2
    Forum Contributor
    Join Date
    03-28-2018
    Location
    Houston, TX
    MS-Off Ver
    Microsoft Office Professional Plus 2016
    Posts
    127

    Re: Need help filling a cell based on an Account code

    Quick question, is the expense code always 9 digits where the first 6 are the account code and the last 3 are the vendor code? More specifically, is the account code always the same length and in the same position within the expense code?

  3. #3
    Forum Contributor
    Join Date
    03-28-2018
    Location
    Houston, TX
    MS-Off Ver
    Microsoft Office Professional Plus 2016
    Posts
    127

    Re: Need help filling a cell based on an Account code

    Ok. Let me just throw my idea at you and you can run with it unless you need additional help. I've attached a workbook with some made up data and then some made up account codes that correspond to some account names. This method uses a lookup to get what you're looking for with a much simplified formula. Let me know if you need any further direction.

    Thanks!
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    06-04-2019
    Location
    Conway, AR
    MS-Off Ver
    2010
    Posts
    3

    Re: Need help filling a cell based on an Account code

    Yes, they are always the same length

  5. #5
    Registered User
    Join Date
    06-04-2019
    Location
    Conway, AR
    MS-Off Ver
    2010
    Posts
    3

    Re: Need help filling a cell based on an Account code

    Thank you so much!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Filling Cell Based on Two Other Formulas
    By csheedy in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-05-2016, 04:07 PM
  2. IF Statement that will assign account types based on "account number"
    By aladdin16 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 12-08-2014, 05:04 PM
  3. Adding Owner Name Based on Account Code in Column A
    By t.tango in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-31-2013, 01:37 PM
  4. [SOLVED] How to censor account numbers based on how many characters are in the account number
    By Mcorydon in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 04-25-2013, 01:06 PM
  5. Replies: 2
    Last Post: 01-26-2011, 02:13 PM
  6. VBA code for automatically filling out cells based on numbers. Similar to list dbase.
    By giallofever in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-30-2009, 03:24 PM
  7. Code for auto filling in Excel based on number of months, & start date
    By Diane Sulton in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-28-2006, 09:20 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1