VLOOKUP

[sydney]

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.

 

[T. Valko]

I want to have it look up another sheet in a different

workbook and I don't know how.

Open the other file.
Start typing in the formula:

=VLOOKUP(A47,

When you get that far use your mouse and point to the table in the other
file. Excel will add the path for you. Then just finish the rest of the
formula. When your done and satisfied with the result, close the other file.

 

[Dylan @ UAFC]

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