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.