Very specific IF question

[bmwkim]

I am using Excel for the accounting of my hobby "company." As you may know, there are assets, liabilities, revenue, etc.

Under a column of "Assets" in my tab called "Financial Statements," I have sub-ledgers such as:
1000 / Cash
1010 / Equipment
1050 / Accounts Receivable
1600 / Notes Receivable
where "/" means the cells are separated

In my tab called "General Ledger," I have a two columns concerned. The first, column A, says the sub-ledger account #, such as "1050."

The second column is where I need help. Here, I am trying to categorize which main account these sub-ledger accounts go to. So when I write journal entries, I want all any values from Column A to return a general account in Column B such as "Asset" "Liability" "Revenue", etc.

So I am trying to link the cell to the left (containing a # like "1050") with the array of numbers (shown above) from tab "Financial Statements" to the formula into Column B of tab "General Ledger."

Can anybody help me with this? I couldn't find anything like this anywhere else.

 

[Khalid NGO]

Hi and welcome to the forum...

It is not 100% clear what you want to achieve with the description.
Can you post a sample with dummy data plus expected results?

This will help users you provide you targeted solutions.

Regards,

 

[udprocks]

crosspost

http://www.excelforum.com/excel-formulas-and-functions/1076704-very-specific-if-question.html

 

[bmwkim]

As you can see the yellow highlighted cells, those entries would be the cells that I am trying to write a formula for. I see that for assets (1000,1110,1120,1130) there are four sub-ledger accounts. If I ever put ANY of those four numbers into the GL # column, I want the column marked A/L/OE,etc. to return automatically "A" for Asset. Same goes for the other accounts.

Please let me know if I can clarify further.

 

[Luke M]

Having your data table setup properly is the key. If you re-arrange it, we can make the ledger function very nicely with a couple of formulas. Check out the attached. With the new layout, all you have to do it enter the GL#, and the formulas fill in the next 2 columns.

 

[bmwkim]

Luke,

You have solved my problem. Thank you.

 

[jeffreyweir]

bmwkim: can you read this and then update the thread at the post on the other forum so that people there know you have solved the issue:
http://www.excelguru.ca/content.php?184

 

[bmwkim]

Sorry. This was my first ever post. I've now cross-posted.