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


--
joel51
------------------------------------------------------------------------
joel51's Profile: http://www.excelforum.com/member.php...o&userid=28749
View this thread: http://www.excelforum.com/showthread...hreadid=484489

#N/A means that, appearances to the contrary, there is not, in fact, a
match. Check for trailing spaces.


"joel51" wrote in
message ...

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


--
joel51
------------------------------------------------------------------------
joel51's Profile:
http://www.excelforum.com/member.php...o&userid=28749
View this thread: http://www.excelforum.com/showthread...hreadid=484489

If you're matching on what looks like numbers, then this could be your problem.

'123 (text)
won't match
123 (numbers)

Changing the format isn't enough. You'd have to change the value, too.

Debra Dalgleish shows a couple of trouble shooting tips:
http://contextures.com/xlFunctions02.html#Trouble

joel51 wrote:

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

--
joel51
------------------------------------------------------------------------
joel51's Profile: http://www.excelforum.com/member.php...o&userid=28749
View this thread: http://www.excelforum.com/showthread...hreadid=484489

--

Dave Peterson