Have a report and one cell I need to change the the field where the gl account is in. When I change the column to where the GL account is, Excel says there is an error yet there is no error in the formula as all I am changing is the GL account.

Formula is =GLACTUALYTD($c94,$b$1,$b$b2,$b$3,,AD1)

B1=Year

B2=period

B3=Company

C94 is GL account (main)

AD1 = Tree

When I change the column C94 to B94 excel throws an error saying the formula is wrong, yet I don't see anything wrong.

Any help would be welcome

Thanks