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
5 registered (Mr. Webmaster, Howard S.-MMA, Softrak Support, Sudhakar, Warren Karges), 362 Guests and 9 Spiders online.
Key: Admin, Global Mod, Mod
Forum Stats
1867 Members
5 Forums
14576 Topics
71139 Posts

Max Online: 1408 @ 12/09/25 01:48 AM
December
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