Topic Options
#45684 - 05/11/15 05:24 AM GL Account Description
Lyndon_Olfert Offline
Adagio Specialist

Registered: 06/15/04
Posts: 362
Loc: Winnipeg
I need your help. How do I get the account description for a specific account/dept pairing? I have a financial report that is combining the information from three separate departments into one report. I need the account descriptions from the account number in cell B12 (a .Range cell) and the department in cell F5 (a column header).

Thanks!
_________________________
Lyndon Olfert, CPA, CGA, CAFM
President - Aboriginal Strategies Inc.

Top
#45710 - 05/11/15 10:47 AM Re: GL Account Description [Re: Lyndon_Olfert]
Lyndon_Olfert Offline
Adagio Specialist

Registered: 06/15/04
Posts: 362
Loc: Winnipeg
I answered my own question. The answer is:
=GLDESC("Costs and expenses",3,RNGMERGE($B12,F$5))
_________________________
Lyndon Olfert, CPA, CGA, CAFM
President - Aboriginal Strategies Inc.

Top


Moderator:  Christa_Meissner 
Who's Online
0 registered (), 69 Guests and 0 Spiders online.
Key: Admin, Global Mod, Mod
Forum Stats
1865 Members
5 Forums
14485 Topics
70732 Posts

Max Online: 432 @ 01/20/25 10:17 PM
May
Su M Tu W Th F Sa
1 2 3
4 5 6 7 8 9 10
11 12 13 14 15 16 17
18 19 20 21 22 23 24
25 26 27 28 29 30 31