View Single Post
  #1   Report Post  
joel51
 
Posts: n/a
Default VLOOKUP function


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