PULL Function Help

travisc

Board Regular
Joined
Oct 19, 2005
Messages
137
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 :)
 

Some videos you may like

Excel Facts

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.

travisc

Board Regular
Joined
Oct 19, 2005
Messages
137
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.
 

travisc

Board Regular
Joined
Oct 19, 2005
Messages
137

ADVERTISEMENT

ttt
 

travisc

Board Regular
Joined
Oct 19, 2005
Messages
137
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
Joined
Oct 19, 2005
Messages
137
B8 is the mold number. B6 is the date. The vlookup for the month, returns the name of the month.
 

Watch MrExcel Video

Forum statistics

Threads
1,127,339
Messages
5,624,103
Members
416,011
Latest member
chengkoonwing

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?

Disable AdBlock

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

Disable AdBlock Plus

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
Top