max wrote:
Hi all,

Im 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 doesnt 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

=========
Can you send the excel-file ?
This is too complex.

thnks

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200906/1