Weird Error on Index-Match. Can someone tell me the reasson?

[griruy]

Hi,
Attached is a workbook with a simple Index Match.
It gives an error starting at 220.3.
If i put 220.3 mannually it fixes the others also.
Can someone tell me what is causing it? and how i can fix it and still use formulas?

Thanks,
Eran.


IndexMatchError.xlsx

[Glenn Kennedy]

Hi. Try this in A2:
=ROUND(A1+0.1,2)

if you prefer to use a few more decimal palces, increase the 2. Why does this happen? Computers can't count.

See: https://support.microsoft.com/en-gb/kb/78113

[griruy]

Thank you very much Glenn.

[Glenn Kennedy]

You're welcome... and thanks for adding reputation.