How to save a formula that's not finished

In this example, I’m working with anINDEX MATCH formulathat has a problem.

Each time I give a shot to enter the formula, Excel complains.

To do that, just put a single quote or apostrophe in front of the equal sign.

This causes Excel to stop trying to evaluate the formula and instead treat it as text.

Later, when you have more time, you might simply reverse the process.

Just remove the apostrophe, and continue working with the formula.

Once you fix the problem and press Enter, the formula will work normally.