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

Shade all formula cells
To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.

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.

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

1,164,625
Messages
5,838,427
Members
430,547
Latest member
jopshio

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.
Allow Ads at MrExcel

Which adblocker are you using?

Follow these easy steps to disable AdBlock

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

Follow these easy steps to disable AdBlock Plus

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