Hello all, one of my users keeps getting this error #Name? for the following
yield fomula
=(YIELD(TODAY()+3,L10,((VLOOKUP(YEAR(L10)-YEAR(TODAY()),$P$7:$Q$22,2,FALSE)+J11/100))/100,I11,100,4)*100)

She fixes it and when she sends it to someone else they get the error or if
she opens it at a later time she gets the #Name? again. It was created in
excel 2003 but then she used excel 2007 to make changes but saves it in 2003
format.

Any help would be much appreciated.

Thanks,
Eddie