VLOOKUP function

[joel51]

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

[Jezebel]

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


"joel51" <[email protected]> wrote in
message news:[email protected]...
>
> 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]

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