R
R0bert0
How do I set up a vlookup to not return an #N/A if the formula can'
find a match in the lookup sheet?
The lookup sheet contains a list of production data downloaded for
particular day. The main sheet is used to plan the next batch o
production. BUT there will almost certainly be some items on the mai
sheet that don't appear on the download. This then returns an #N/A i
the relative plan cell which in turn thows out my totals formulas an
makes the whole thing look untidy.
Is there a way to formulate the cell to return a blank or a zero if th
vookup doesn't find a match?? thanks for your help!
find a match in the lookup sheet?
The lookup sheet contains a list of production data downloaded for
particular day. The main sheet is used to plan the next batch o
production. BUT there will almost certainly be some items on the mai
sheet that don't appear on the download. This then returns an #N/A i
the relative plan cell which in turn thows out my totals formulas an
makes the whole thing look untidy.
Is there a way to formulate the cell to return a blank or a zero if th
vookup doesn't find a match?? thanks for your help!