Hi all,

I’m trying to enter this as Validation formula. My problem is it
evaluates to #N/A.
It had evaluated fine as a cell formula before shortening everything
to Named Formulas
Now, even as a regular cell formula, it doesn’t work.
Could it have something to do with Workbook vs Worksheet scoping?

The sheet for the validation is called RECIPES.
Any ideas?

P - QTY

=IF(OR($D2="",$E2=""),"",P_QTY_Formula/Pur_Unit_Wt.oz_Formula)
================================================== ==========

P_QTY_Formula

=(OFFSET((OFFSET(ItemStart,MATCH($C2,ItemColumn,0) ,0,1,1)),0,(MATCH
($E2,(OFFSET(ItemStart,MATCH($C2,ItemColumn,0),2,1 ,3)),0))+4,1,1))*$D
$2


Pur_Unit_Wt.oz_Formula

=INDEX(Pur_Unit_WT.oz,MATCH($C2,ItemColumn,0))

Thanks