how do i setup vlookup to look up in a different excel spreadsheet

[Chok]

I use VLOOKUP function quite a bit..Lately I have a need to lookup values
from a different excel worksheet range..How can i specify the The path,file,
and the range to do it ?

 

[Dave F]

Do you mean a range in an external workbook? If so, the syntax would be
something like: =VLOOKUP(D1,'[other workbook.xls]sheet1'!$E$1:$G$118,2,FALSE)

 

[Dave Peterson]

Open that sending file
start your =vlookup() formula

type
=vlookup(a1,
But then use window (on the menubar) to go to that other workbook and worksheet.
point at the range to use (say all of book2.xls, sheet99, columns A:E)

then type
,2,false)

and hit enter.

Close the other workbook and you'll see how excel likes the syntax.

(I do my best to not remember this kind of stuff. If I can point and click and
let excel do the heavy lifting, it makes life much easier for me.)