Hi Guys having a bit of trouble on this excel sheet. When I use evaluate, it goes to 1.14 and in the input data sheet there is data but when I evaluate it returns N/a . The maddening part is it works for 2.14,3.14,4.14 , etc. but just not 1.14 and the other sister value of 1.16 beside it`
`=IF(HLOOKUP($C$21+$CC$8,Input_Data!$A$2:$BIN$2502,$BZ10,FALSE)
<>0,HLOOKUP($C$21+$CC$8,Input_Data!$A$2:$BIN$2502,$BZ10,FALSE), #N/A)`
[Lookup Data that is there](https://i.sstatic.net/bZkj1DoU.png)
[Calculation](https://i.sstatic.net/TMAeP9bJ.png)
[N/A](https://i.sstatic.net/LR3oCCid.png)
SORRY stack overflow made me make the picture links like that
New contributor
Korea Sauce is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.