Then it's prpbably a rounding issue. As advised, increase the number of
decimals to find the error or round both your table and the search argument

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"KevinM" wrote in message
...
I refer back to a cell that contains the percentage and it can be in a
range 100% - 100.99% which is why i am using true and not false