Sometimes you have a formula that isn't finished and Excel won't let you save the formula. In this video, we'll look at a simple way to save an unfinished formula so that you don't lose your work.
Sometimes you might be working on a formula that's broken or unfinished and Excel won't let you enter it as is.
In this example, I'm working with an INDEX MATCH formula that has a problem. Each time I try to enter the formula, Excel complains.
This isn't such a big problem if you have plenty of time, but maybe you need to stop work and save the worksheet for another day.
In that case, there's an easy way to temporarily change the formula into text so that you can enter it and save the workbook.
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 can 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.
The Excel INDEX function returns the value at a given location in a range or array. You can use INDEX to retrieve individual values, or entire rows and columns. The MATCH function is often used together with INDEX to provide row and column...
MATCH is an Excel function used to locate the position of a lookup value in a row, column, or table. MATCH supports approximate and exact matching, and wildcards (* ?) for partial matches. Often, MATCH is combined...