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:  Softrak Support 
Who's Online
0 registered (), 105 Guests and 1 Spider online.
Key: Admin, Global Mod, Mod
Forum Stats
1867 Members
5 Forums
14569 Topics
71099 Posts

Max Online: 1148 @ 11/22/25 01:55 AM
November
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