Dear All,

I have had accurate results with INDEX and MATCH functions combined. The
best part is, the data need not be in ascending order. Regardless of the
arrangement of data, one can easily look up the values with ease.

Best regards,
Satadru

"Max" wrote:

=VLOOKUP(A6,'[2008 Projection.xls]08 PROJ'!A$9:C$191,3)

As-is, you need to ensure that the values in the table array's lookup col
are sorted in ascending order

Alternatively, amend it for exact matching, viz.:
=VLOOKUP(A6,'[2008 Projection.xls]08 PROJ'!A$9:C$191,3,0)
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:17,500 Files:358 Subscribers:55
xdemechanik
---
"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.