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 |
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 |
All times are GMT +1. The time now is 07:00 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com