Forum Discussion
IFERROR & VLOOKUP / If Month formula issues
I copied and paste 2 formulas related to 1) IFERROR and VLOOKUP, and 2) IF/Month from a known good spreadsheet into a new spreadsheet, and they stopped working. I spent hours debugging then and found...
Cells A2 to C2 are formatted as Text, so they display the formulas as text instead of evaluating them.
Select A2:C2.
Set the number format to General.
Select the cells one by one, press F2 then Enter.
The formulas in A2 and B2 will return a value, but the one in C2 will return #VALUE!. This is because the formula refers to MONTH(Y2) and YEAR(Y2), but Y2 does not contain a date.
