jessieg1906
Occasional Contributor

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?

1 ACCEPTED SOLUTION

Accepted Solutions
Aswinraj
Contributor

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.

View solution in original post

3 REPLIES3
Aswinraj
Contributor

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.

jessieg1906
Occasional Contributor

It was! Thank you!

rohan.suratwale
Frequent Contributor

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