ibleafnmajic
New Member
- Joined
- Oct 1, 2019
- Messages
- 1
Team,
Trying to keep this example simple.
I have a pivot table:
<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)
<tbody>
</tbody>
Thank you for your time!
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>
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!