using an Array formula

Hi ,

Have some trouble using an Array Formula, (index and match, to performe a lookup based on two columns)

I can only run the report correctly If I run the report in designer mode, and every time I have to re- enter (control-shift-enter) this formula to run the report correctly,
then I save the report, rerun it from viewer mode, gives me a value error

any advise is appriciated


Please sign in to leave a comment.