Forum Discussion

Lee_Koh's avatar
Lee_Koh
Copper Contributor
Sep 21, 2020

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...
Formulas and Functions
Lee_Koh's avatar
Lee_Koh
Copper Contributor
Sep 21, 2020

Hi SergeiBaklan,

 

Thank you much for your help. It worked after I followed your instructions. Why would a General Format (instead of text) cause the problem? What does F2/Enter do to the existing formula?

 

Also, The formula in C2 should refer to Q2 (instead of Y2) as on date. Thanks for pointing it out.

 

Lee 

SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Sep 21, 2020

Lee_Koh 

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. 

  • Lee_Koh's avatar
    Lee_Koh
    Copper Contributor
    Sep 21, 2020
    I got it. thank you foe your help.

    Lee

Resources