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
1 registered (Softrak Support), 44 Guests and 0 Spiders online.
Key: Admin, Global Mod, Mod
Forum Stats
1865 Members
5 Forums
14465 Topics
70658 Posts

Max Online: 432 @ 01/20/25 10:17 PM
April
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