Can Vlookup from one spreadsheet and not another
Hello,
I have a simple spread sheet (Quantities) where I'm trying to vlookup a
value (ItemNumber) from another spreadsheet (ItemMaster) to return Units.
The vlookup constantly returns #N/A despite the fact that I can see the
ItemNumber it's supposed to be looking up. I can look up the same ItemNumber
from a different spreadsheet (that holds similar info) with no problem.
Any ideas on what would keep a vlookup from working on ItemMaster only?
Melinda
|