Hi,

Can someone take a look at my excel file and explain to me why is my formula not working please ?

If you take a look in the file at the sheet "MOOZ.F" you will see a red cell. In that cell I have a formula that should show MOOZ.A E219 as a result but it doesn't.

I found out that the problem is with the cell MOOZ.A A219. If I delete the number 77245 from inside the cell and I write it manually again then the formula in MOOZ.F will work.

Can someone explain what characteristics does the cell in MOOZ.A have that it's not recognised by the formula in MOOZ.F ?

This problem is present in a few other cells too. The formula works for some of the cells, but for others it doesn't.

I tried to format the cells in MOOZ.A but I coudn't figure it out. I must mention that the solution should work on excel 2007.

Thank you for your time