Match (NA error)

[Median]

Another brain teaser, I can't for the life of me work out why AA9 returns N/A

Manually typing 1.66 in Y9 fixes the problem - but I shouldn't need to do this (& assumed the formula in Y9 is "1.66" exactly)

[samba_ravi]

use below formula in Y9
=ROUND(1/(1/INDEX(B3:W3,1,22-$Y$3+1)+$AA$3)-0.005,2)
instead of =FLOOR(1/(1/INDEX(B3:W3,1,22-$Y$3+1)+$AA$3),0.01)

[samba_ravi]

or can use
=ROUNDDOWN(1/(1/INDEX(B3:W3,1,22-$Y$3+1)+$AA$3),2)
in Y9

[dosydos]

- Deleted-
Formula was incorrect

[Median]

Appreciated guys!