i have this formula that i am using as an array , but it gives me an error
message. i am trying to use the formula on a page called "calculations".. the
information being used is on a page called "client" .. i am also indirectly
referencing a cell "O1" on the calculations page so that i dont have to
change the formulas all the time.. can someone tell me why this doesnt work??

=MAX(IF(INDIRECT("CLIENT!$I$2:$I"&$O$1)="HOMESIDE" ),(INDIRECT("CLIENT!$E$2:$E"&$O$1)))