Forum Discussion
Solved
Partial Miss Match of Vlookup
What I want to do is to find every number of column A in column E and print the relating value in B. I find that almost 10% of the number is missed. I have checked all the possible errors like spa...
That is rounding error issue, more about it here EXCEL: RANK, COUNTIF, AND FLOATING POINT ERRORS If check xml components of your file, quite many numbers looks like
I don't know how did you take them, better to pull numbers correctly. Otherwise use something like
=VLOOKUP(ROUND(E2,15),ROUND(A$1:B$300,15),2,FALSE)and take into account rounding error could appear in other calculations as well.
