View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Melinda
 
Posts: n/a
Default 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