Even with calculation set to manual, the cell should recalculate after
making a find and replace change. Your formula is set to return a
blank, "", if the MATCH portion of the formula fails. Does the value
of N12 exist in Schedule!E49:E102?