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...
If cell is formatted as text, whatever you enter into it will be taken literally as you typed it. Even if such text is in form of date, formula, number - that's just a text.
If you format the cell as General when Excel recognizes you enter something else. If this else start from = Excel interprets what was entered as formula.
If you press F2 you shift on cell edit mode (you may edit cell content directly within it, not in formula bar). Pressing Enter you finish the editing.
Above are main topics, something could be done by another way.
I got it. thank you foe your help.
Lee
Lee
Lee_Koh , you are welcome