Using index match formula, all works fine except for certain cells it returns 0 for the value. I've checked for spaces and have checked formatting of cells and nothings seems to be in error. The formula is in worksheet BOMUPHOL and a typical cell that isn't calculating is cell K354. It should be returning a value of 13 from BOMASSEMBLY. Please help as I have tried everything. Thanks and let me know if there is anything else I can add.