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 (), 195 Guests and 7 Spiders online.
Key: Admin, Global Mod, Mod
Forum Stats
1868 Members
5 Forums
14581 Topics
71178 Posts

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