I'd open that workbook that's in z:\folder A\Folder B, then create the
=vlookup() formula.

When you close that "sending" workbook, you'll see that excel did the heavy
lifting and made sure the syntax was correct.

Daffy Duck wrote:

I am attempting to do a vlookup that accesses another drive AND traverses
multiple folders before reaching the object xls.
A current example of what has worked to access a different drive and one
folder is:
=VLOOKUP(A10, 'Z:\FOLDER A\[Wks.xls] Tab A'$A$1:$Z$10,2,FALSE)*100

How do I go to Drive Z, to access an xls in Folder B which is inside of
Folder A? I already attempted another backslash similar to the following:
=VLOOKUP(A10, 'Z:\FOLDER A\FOLDER B\[Wks.xls] Tab A'$A$1:$Z$10,2,FALSE)*100

But didn't have any luck.

--

Dave Peterson