Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLOOKUP
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLOOKUP
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. -- Biff Microsoft Excel MVP "sydney" wrote in message ... 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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLOOKUP
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLookUp - Does the VLookUp return the exact information? | Excel Worksheet Functions | |||
Vlookup in vlookup - taking the result as array name | Excel Worksheet Functions | |||
Combine VLOOKUP and IF function so #NA isn't returned as a value from VLOOKUP | Excel Discussion (Misc queries) | |||
Vlookup -=VLOOKUP(F9,LookUp1!$A$2:$B$1504,2,FALSE) | New Users to Excel | |||
Vlookup info being used without vlookup table attached? | Excel Worksheet Functions |