How To Correct Value Error In If. INDEX and MATCH should be used as an array formula which means you need to press CTRLSHIFTENTER. Although not always recommended you can use the IFERROR function to handle the Value.
So either press ENTER only if you have Microsoft 365 or CTRLSHIFTENTER. If you have any query feel free to use the comment section below. You can use any of the error-handling formulas such as ISERROR ISERR or IFERROR along with IF.
Error when doing even the most basic subtraction formula.
Value_if_error this is the value that is returned if there is an error. If you are using INDEX as an array formula along with MATCH in order to be able to retrieve a value you will need to convert your formula into an array formula otherwise you will see a VALUE. To eliminate the VALUE error in your array you must close the formula by typing CTRL SHIFT ENTER rather than the standard ENTER. To correct this error we need to enter the proper date value in cell B3.
