I ran yours and it didn't do anything until i played with cells within the rows i want to hide and unhide.
Here is exactly what I have:
page 1 is titled LINES that is formatted to look like a serving line. it has cells with validation list of recipe names linked to a combobox.
page 2 has a list of recipe names and recipe numbers and I'm working on adding inventory names for each recipe.
page 3 is a production schedule with links to page one so the selected recipes automatically populate in the cells on the prduction schedule. the cells next to the recipe name on the production schedule have a vlookup formula to look up the recipe name from page 2 and return the recipe number. then there is a hyperlink to the pdf recipe cards so they can be printed from the same page.
page 4, the one i want to hide and unhide cells on, is a kitchen requisition. the cells that i want to hide, have the formula i posted before to look up the recipe name from the production schedule on page 3 from the recipe name page and return the ingredients for the recipe. Eventually, it will be linked to my inventory to automatically draw out.
All i need is for the cells to hide and unhide automatically. the zeros come when there is nothing in a particular cell on the production schedule, hence nothing to be ordered. Here is the formula again so you can look at it.
I have a worksheet, used as a requisition. In column A, rows 12-78, there is a formula:
IF(ISNA(VLOOKUP('Dinner Production Schedule'!C14,RecipeNumbers!$B:$E,3,FALSE)),0,VLOOKUP('Dinner Production Schedule'!C14,RecipeNumbers!$B:$E,3,FALSE))