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

[ibleafnmajic]

Team,

Trying to keep this example simple.

I have a pivot table:

	A	B	C
1	Aisle	# Locations	Units
2	001	229	1569
3	002	1	-12
4	003	12	214

<tbody>
</tbody>

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)

Aisle	# Locations	Empty Locations	Utilized Locations	Units
001				=VLOOKUP([@Aisle],A:C,3,0)
002				#N/A
003				=VLOOKUP([@Aisle],A:C,3,0)

<tbody>
</tbody>

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...