Gary,
Shouldn't there be some Sheetname in there also ?

=VLOOKUP(A2,[Book1.xls]Sheet2!$A$1:$O$37,3)

NickHK

"Gary Keramidas" <GKeramidasATmsn.com wrote in message
...
i have a client that uses a vlookup formula. the sheet it references has
about
23k records.
=VLOOKUP(A5,'2007 Data.xls'!$A$2:$W$22670,23,0)

the workbook with the vlookup formula may only have 20 rows of data.

the error is "excel cannot complete the task with available resources.
choose
less data or close other applications"

this works on some pc's and not others. on some it doesn't work on, it may
work
when logging in as another user.

once it pops the error, it's like that workbook is locked up and task
manager
has to be used to close it.

just wondering if anyone had any ideas?


--


Gary