Hi,

Not sure what you mean by "with an array"

The following formula works just fine.

=VLOOKUP(A1,tblBookSales.xls!$A$1:$E$101,3,FALSE)

Note you are doing an approximate match so the lookup column, the first
column in the lookup table must be sorted in Ascending order.

--
Cheers,
Shane Devenshire


"Cobaum" wrote:

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.