Vlookup Pathway

D

Daffy Duck

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.
 
D

Dave Peterson

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 said:
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.
Click to expand...
 
J

JMB

it doesn't look like my first post went through

I think you need an ! here:

Tab A'!$A$1
 
D

Daffy Duck

Dave,
Thanks much for the insight about closing the sending workbook. I had tried
the same step but unless the sending is closed the pathway wasn't refleted in
the formula. Therefore I didn't believe the formula was feeding correctly.
In addition, I had a #NA that was confusing the issue. Completely resolved.
I appreciate your time and help!!


Dave Peterson said:
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 said:
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.
Click to expand...
Click to expand...
 
D

Dave Peterson

Lots of times when I use =vlookup(), I'll start my formula and get to this
point:

=vlookup(a1,

Then I'll use the mouse and go to the other worksheet (even in a different
workbook) and point at the range to use as the table.

Then I don't have to worry about any of that syntax. (I may go back and change
the cell references to absolute (A1 to $a$1) if I need to.)

But any work excel can do for me is one less thing I can screw up!

Daffy said:
Dave,
Thanks much for the insight about closing the sending workbook. I had tried
the same step but unless the sending is closed the pathway wasn't refleted in
the formula. Therefore I didn't believe the formula was feeding correctly.
In addition, I had a #NA that was confusing the issue. Completely resolved.
I appreciate your time and help!!

Dave Peterson said:
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 said:
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.
Click to expand...
Click to expand...
Click to expand...
 
Top