PULL function for Excel 2000?

[travisc]

Anyone know where I can get a PULL function that works with newer Excel versions? Or maybe even remake the original PULL function so it works with newer versions?

Thanks,
Travis

 

[travisc]

Got another idea here...

=IF(ISNUMBER(VLOOKUP($A4,'\\BUNT5DCSRV1\storage\Butler\BM_MFG\Production Reports\2006 Production Reports\May 06''\Labor\[2nd Shift Labor.xls]1'!$B$3:$C$86,2,FALSE))=FALSE,"",VLOOKUP($A4,'\\BUNT5DCSRV1\storage\Butler\BM_MFG\Production Reports\2006 Production Reports\May 06''\Labor\[2nd Shift Labor.xls]1'!$B$3:$C$86,2,FALSE))

I just eliminated the DAY(), and put the day in myself... now the problem I'm having is if that sheet doesn't exist... instead of just returning an #NA or other error... it won't let me enter the formula.

 

[travisc]

I started changing all my formulas to this, then encountered the problem with a sheet not existing...

Each sheet represents a day of the month... and if it's a Sat/Sun, it doesn't have a sheet...

 

[Zack Barresse]

So do these formulas have to update from the files? Do you have Update remote references and Save external links checked in Tools | Options?

 

[travisc]

yea both are checked.

 

[Zack Barresse]

You know, I don't know if this is it or not, kind of a long shot. But your cell which houses your text string to be looked at by the Pull() function, what exactly do you have in there? And I mean copy/paste exactly what you have from your formula bar - everything in there.

 

[Zack Barresse]

Okay, what I'm thinking, is if you have something like this as your text from your formula bar ...


'C:\Your\Path\Here\[Book13.xls]Sheet1'!A1:C10

.. it will not work. This is because Excel interpets the first single apostrophe ' sign as saying "this is text" and will not show it in the cell. If you want it to show up, you'll need two[/i] single apostrophe '' signs; not be be confused with the single quote " sign(s).

So the above would be ...

''C:\Your\Path\Here\[Book13.xls]Sheet1'!A1:C10

Try it out and let us know.