I need help in understanding why I am getting a #N/A error when there is a match. The lookup table is a table of "Subtotaled" data. I am able to match the majority of the subtotals but there are a few where the #N/A error happens even with a match.

I have checked the format, spaces etc and am at a lose.

Any help would be greatly appreciated.

Joel