Value VLOOKUP is searching for is negative - returns #N/A

[ibleafnmajic]

Team,

Trying to keep this example simple.

I have a pivot table:
[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Aisle[/TD]
[TD]# Locations[/TD]
[TD]Units[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]001[/TD]
[TD]229[/TD]
[TD]1569[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]002[/TD]
[TD]1[/TD]
[TD]-12[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]003[/TD]
[TD]12[/TD]
[TD]214[/TD]
[/TR]
</tbody>[/TABLE]
I am trying to combine information in a spreadsheet from three pivot tables using the VLOOKUP.
However, when I try to display the # of units from Aisle 002 I receive the error message #N/A. But the formula works for all positive numbers.

This is the formula I am using in the other spreadsheet:

=VLOOKUP([@Aisle],A:C,3,0)


[TABLE="width: 500"]
<tbody>[TR]
[TD]Aisle[/TD]
[TD]# Locations[/TD]
[TD]Empty Locations[/TD]
[TD]Utilized Locations[/TD]
[TD]Units[/TD]
[/TR]
[TR]
[TD]001[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]=VLOOKUP([@Aisle],A:C,3,0)[/TD]
[/TR]
[TR]
[TD]002[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]#N/A
[/TD]
[/TR]
[TR]
[TD]003[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]=VLOOKUP([@Aisle],A:C,3,0)[/TD]
[/TR]
</tbody>[/TABLE]


Thank you for your time!

 

[RasGhul]

=VLOOKUP([@Aisle],Sheet1!A:C,3,0) is working for me with Aisle as text or numbers, on the same sheet or different sheets.

Is there possibly any accidental spaces in the Aisle data? maybe check the formula evaluation steps to see if the lookup value is matching...