Data mismatch error


currently working on the level one exam and stuck on question 6 with rev04 model getting the formulas in. i know the formulas are right but the error pops up. so is there another step before entering the formula that i should be doing to bypass this error?

Best Answer

  • Aswinraj
    Answer ✓

    Hi Jessie,

    If this is something that has to do with the calculations of operating expenses, Check with the line items that are referenced in the formula whether have the correct format to fit in the arguments of LOOKUP. Hoping, it will be useful.


  • Hi @jessieg1906 ,

    I think the best way to help you would be if you can share the screenshot for the error,

    If the Error anywhere says  "Invalid" , there is a possibility of Syntax error.

    -- ROHAN

  • It was! Thank you!