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

ibleafnmajic

New Member
Joined
Oct 1, 2019
Messages
1
Team,

Trying to keep this example simple.

I have a pivot table:
ABC
1Aisle# LocationsUnits
20012291569
30021-12
400312214

<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# LocationsEmpty LocationsUtilized LocationsUnits
001=VLOOKUP([@Aisle],A:C,3,0)
002#N/A
003=VLOOKUP([@Aisle],A:C,3,0)

<tbody>
</tbody>


Thank you for your time!
 

Some videos you may like

Excel Facts

Select all contiguous cells
Pressing Ctrl+* (asterisk) will select the "current region" - all contiguous cells in all directions.

RasGhul

Well-known Member
Joined
Jul 15, 2016
Messages
609
=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...
 

Watch MrExcel Video

Forum statistics

Threads
1,099,004
Messages
5,465,955
Members
406,455
Latest member
mkadam

This Week's Hot Topics

Top