Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vlookup
vlookup formula error. I changed names of sheets in catering
Destinations-Directions worksheet. I'm using this formula to designate a worsheet with a specific sheet in it. =VLOOKUP($J$4,'[Catering Destinations-Directions.xls]#REF'!$A$1:$O$5134,11,FALSE) the error is #REF. I'm thinking i need to put name of sheet there, but whatever i put in returns error. thanks for any help |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vlookup
Please don't multi-post. Below is the response to your posting in .misc
Assume that sheetname in Catering Destinations-Directions.xls is: Sheet1 First, open the source file, ie open: Catering Destinations-Directions.xls Check that Sheet1 really exists in there and is named exactly as presumed (except for case). Watch out for any extraneous white spaces in the sheetname. Then in your other workbook, in the sheet containing the vlookup formula it would be this expression: =VLOOKUP($J$4,'[Catering Destinations-Directions.xls]Sheet1'!$A$1:$O$5134,11,FALSE) Do high-five this response by clicking the YES button below -- Max Singapore http://savefile.com/projects/236895 Downloads:23,000 Files:370 Subscribers:66 xdemechanik --- "dwid" wrote: vlookup formula error. I changed names of sheets in catering Destinations-Directions worksheet. I'm using this formula to designate a worsheet with a specific sheet in it. =VLOOKUP($J$4,'[Catering Destinations-Directions.xls]#REF'!$A$1:$O$5134,11,FALSE) the error is #REF. I'm thinking i need to put name of sheet there, but whatever i put in returns error. thanks for any help |
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 |