Hello


I have the below formula that looks up a value for glucose in a recipe from a different sheet, it works fine until the recipe I am looking up doesn't have glucose in and an error N/A value is returned, I need this formula to return a value of 0 or blank if there is no glucose in the recipe.

=IF($E8>0,VLOOKUP($E8,'F:\01 Logistics\SUGAR\[LookupGlucose.xls]LookupGlucose'!$A$1:$D$299,4,FALSE),0)


Thanks



Nick

As you use Office2003, IFERROR() is not an option. So you'll have to use

Many Thanks


Did the job.