I don't understand why one would need to put the round function around a
lookup where the results are not to more decimal places than required.
However, having said that, inserting the round function around the lookup
does cure it.

This would leave me with another question.

How does one easily insert the round function around the lookup - when I
have many forumlas to do and the lookup is using many different filenames
(which, I think, prevents me from using edit replace)?

Thanks again

"Gary''s Student" wrote:

Sometimes people FORMAT a cell to only display 2 digits. The REAL underlying
value ccan still have a tiny bit of roundoff error.

ROUND should be applied to the calculated values before trying lookups.
--
Gary''s Student - gsnu200855


"BabyMc" wrote:

Thanks Gary's Student

I'm not sure I'm with you exactly.

Every value in the table is to 2 decimal places only and my report is only
taking those values and adding or subtracting (no multplication or division)
- so I couldn't see how either could have any rounding error.
In addition I did try putting =ROUND( ,2) round my lookups but that didn't
make any difference.

Would you be able to expplain further what you mean?

Thanks again



"Gary''s Student" wrote:

Your mis-match may be a tiny bit of rounding error. This can be detected by
comparing the two values with an IF statement. It can be fixed by using the
ROUND() function,
--
Gary''s Student - gsnu200855


"BabyMc" wrote:

I have tables of figures which I am extracting, via VLOOKUP, to different
reports. I am then compiling a total, of each of these values, in the reports
themselves.
Then I am comparing the total given in my report with the total that is also
included within the initial table and asking Excel to give me an error
message should the two amounts not balance.

I have done this many times without any issues - however I seem to have a
problem in some reports whereby I am receiving an error message even when the
value in the report matches the value in the table.

I have manually checked that the report adds up correctly - and the value in
the table. I have checked that neither value includes a spurious amount
within the decimal (down to 5 places).
I have also split my formula (that produces and error message) in to its two
halves - and these both return the same result.

I am afraid I can't fathom why I am getting an error message. Can anyone help?

Thanks