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.