Hi Diane,

I understand that you want to make the formula return a blank cell instead of 0% when the index cell is blank. You can modify the formula by adding an IF statement to check if the index cell is blank, and return a blank cell if it is. Here's the modified formula:

1. =IF(ISBLANK(INDEX(Summary!$E$2:$E$79,MATCH(VendorC ommodities_Detail!$C3,Summary!$C$2:$C$79,0))), "", INDEX(Summary!$E$2:$E$79,MATCH(VendorCommodities_D etail!$C3,Summary!$C$2:$C$79,0)))

This formula uses the ISBLANK function to check if the index cell is blank. If it is, the formula returns a blank cell (""). If it is not blank, the formula returns the result of the original formula.

Regarding your concern about the blank cells affecting other calculations, it depends on how those calculations are set up. If the calculations use the same IF statement to check for blank cells, they should not be affected. However, if the calculations assume that the cells contain 0%, they may need to be modified to handle blank cells.