vlookup, naming range in other document with specific sheet

  • Thread starter Thread starter DaleWid
  • Start date Start date
D

DaleWid

Trying to fix my vlookup command. The range is a separate worksheet, a
specific sheet within the worksheet. Following is command with REF error,
need to put name of sheet i believe after name of worksheet but everything i
try returns error. thanks for any help
=VLOOKUP($J$4,'[Catering
Destinations-Directions.xls]#REF'!$A$1:$O$5134,11,FALSE)
 
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
 
Back
Top