Problems with VLOOKUP

[jurassicjamie]

Hi,

I am having problems with vlookup when using using values in a table column and looking up a calculated value. Weirdly it is ok on some rows but not on others.

I have trimmed it down to the bare basics:

In row 2 I have: A '3' B '25' C '=A2+B2/100+0.001' D '=VLOOKUP(C2,$F$2:$G$7,2,FALSE)' F '3.251' G '1'
In row 3 I have: A '3' B '30' C '=A3+B3/100+0.001' D '=VLOOKUP(C3,$F$2:$G$7,2,FALSE)' F '3.301' G '2'

Cell D2 correctly shows '1' but cell D3 shows the error '#N/A'. Can anyone explain why?

I though the problem might be to do with numbers stored as text but have tried using value(...) on the figures and it seems to make no difference.

Thanks!!!!

Jamie

[alansidman]

Change your formula in column C to =ROUND(A2+B2/100+0.001,3)

then read this on floating point issues in Excel.

https://support.microsoft.com/en-us/kb/214118