I'm currently modifying a tab in excel to assemble a printable contract based upon the estimating formulas and functions that have been built out on other tabs in the same worksheet. I have built multiple reference formulas and have been successful at pulling the info over based upon a few variables.
However, I only want this tab to include pages in the page count where the lookup/index formulas on the page do not come back as false or with no information. For example, within the contract I include an "equipment covered in this contract" section. This could be any number of pages from 1 - 10 or more and is only known on a case by case basis. Currently my reference formulas look similar to:
=IFERROR(TRIM(VLOOKUP(B118,'Equipment Reference'!A:B,2,FALSE)), "")
and
=IF(ROWS(A$119:A119)>N$118,"",INDEX('CP Board'!B$27:B$2000,
SMALL(IF(ISNUMBER(SEARCH("PS"&"|",'CP Board'!B$27:B$2000&"|")),
ROW('CP Board'!B$27:B$2000)-ROW('CP Board'!B$27)+1),ROWS(A$119:A119))))
However even if they do not display information on a page (Because all equipment was previously listed) that page still shows in the overall page count (1 of 2 pages....etc.)
Is there a setting, or another way to write the formulas above so that a page is only included if the formula displays information (in this case it would be equipment)?
Thanks for your help!
Bookmarks