I cannot believe the file is to big
it would have to contain over 1,000,000,000 rows
at least to not work.
Put the table in the next sheet and use this formula
=VLOOKUP(A47,SHEET2!$A$1:$B$2779,2,FALSE)
If you have in asending order leave of the false.
If you are planning to auto fill the formlula for more than
one row, MAKE SURE you use the $$$$$, have the
formula absoult will help the fasten things up
Thanks]\
DL

"sydney" wrote:

Right now I have =VLOOKUP(A47,'NAME AND PRICING'!A1:B2779,2, FALSE)

but the file is too big to save the list in this workbook.

The table_array is 'NAME AND PRICING'!A1:B2779 and I want to have it look up
another sheet in a different workbook and I don't know how.