=ADGET("GLDATA.Y",$B12&"-"&I$5)

Will return the year to date value for a account/dept pair.

Where B12 is the .Range and I5 is the department number in the column header.
_________________________
Lyndon Olfert, CPA, CGA, CAFM
President - Aboriginal Strategies Inc.