Vlookup Pathway

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

[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 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

[JMB]

I think you need and ! mark about here

Tab A'!$A$1


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

[JMB]

it doesn't look like my first post went through

I think you need an ! here:

Tab A'!$A$1

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

[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" wrote:

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

[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 Duck wrote:
>
> 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" wrote:
>
> > 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
> >

--

Dave Peterson