In this file, the main function used is:
=IFERROR(IS(ISBLANK(B19),,VLOOKUP(A19,’Cost File’!C:D,2,FALSE)),)
- We are searching for the product code in the Cost File and we return the cost of that specific item: VLOOKUP(A19,’Cost File’!C:D,2,FALSE)
- This operation will only be performed if the cell B19 is not empty (meaning that we introduced an item in the quote – for aesthetical reasons): IF(ISBLANK(B19 …
- If there is an error in the formula mainly due to data not found in the Cost File, the result will be BLANK, Having this set will allow the file to calculate the totals QUOTE (if you are adding cell where, between the values, you have at last one call with an error message), the entire sum will read ERROR instead of the total of the cells with values: IFERROR(…
- We do the same for the other sheets in the document – one sheet for each of the categories we have identified for our data.