# PULL Function Help

#### travisc

##### Board Regular
I've been trying to get this to work for a couple of hours... lol

I'm using Excel 2003.

I'm using Harlan's PULL function, with the last date being, 5-30-04

B4: ="'\\BUNT6DCSRV1\storage\Butler\BM_MFG\Production Reports\2007 Production Reports\" & VLOOKUP(MONTH(B6),\$D\$6:\$E\$17,2) & " " & MID(YEAR(B6),3,2) & "''\Molding\[2nd.xls]" & DAY(B6) & "'!\$A\$7:\$U\$45"

B6: 08/28/2007
B8: 23

23 is a mold number for a tool at work.

The VLOOKUP for the MONTH, is to return the name of the month "January" "February" etc...

These two lines both work:
=VLOOKUP(B8,INDIRECT(B4),1,0)
=VLOOKUP(B8,'[2nd.xls]28'!\$A\$7:\$U\$45,1,0)

This one doesn't:
=VLOOKUP(B8,PULL(B4),1,0)

I've never been able to get PULL to work... lol

### Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.

#### travisc

##### Board Regular
Basically I'm trying to pull a range of data from a variable file path...

There's a folder for each month and year...

January 07'
February 07'
etc...

Then within each monthly folder is a spreadsheet, that has a tab for each day of the month....

I want to type in the date, and have it find the data for the mold number for that specific day.

ttt

ttt

ttt

whooops

#### travisc

##### Board Regular
I'll try to simplify this a little bit.

Code:
``````=VLOOKUP(\$B8,INDIRECT.EXT("'\\BUNT6DCSRV1\storage\Butler\BM_MFG\Production Reports\2007 Production Reports\"&VLOOKUP(MONTH(\$B6),\$D\$6:\$E\$17,2,0)&" "&RIGHT(YEAR(\$B6),2)&"''\Molding\[2nd.xls]"&DAY(\$B6)&"'!\$A\$7:\$U\$45"),12,0)

=VLOOKUP(\$B8,PULL("'\\BUNT6DCSRV1\storage\Butler\BM_MFG\Production Reports\2007 Production Reports\"&VLOOKUP(MONTH(\$B6),\$D\$6:\$E\$17,2,0)&" "&RIGHT(YEAR(\$B6),2)&"''\Molding\[2nd.xls]"&DAY(\$B6)&"'!\$A\$7:\$U\$45"),12,0)``````

The indirect.ext works, but the pull doesn't... everything else is exactly the same. what's my problem, any ideas?

#### travisc

##### Board Regular
B8 is the mold number. B6 is the date. The vlookup for the month, returns the name of the month.

Replies
4
Views
119
Replies
2
Views
123
Replies
12
Views
375
Replies
8
Views
148
Replies
3
Views
318

1,128,165
Messages
5,629,068
Members
416,363
Latest member
zaveedd

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back