View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Cobaum Cobaum is offline
external usenet poster
 
Posts: 15
Default vlookup - lookup with an array in another workbook?

I am trying to lookup values in one workbook from an array in another
workbook. Can this be done? I am getting #N/A errors from a perfectly good
vlookup formula. I am assuming that it does not like the second workbook.
If that is an incorrect assumption, let me know what else I should check.
Here's the formula for those that want to check it: =VLOOKUP(A6,'[2008
Projection.xls]08 PROJ'!A$9:C$191,3). Thanks in advance.