Hi, I am having a similar problem with a spreadsheet I am working with.

I am using a simple 'Match()' function, but occasionally it will not recognize the exact number, and spits back '#N/A'. This occurs randomly, as the majority of the cells with the Match function work properly.

How did you solve your problem?

Thanks,