Referencing an external workbook in a custom formula

[outthere]

Hey Everyone,

I am trying to write my first custom formula. All I want it to do is to semi automate a lookup formula. I am trying to look up a value in an excel file located on our file server.

Here is what I have so far:

Please Login or Register  to view this content.

Can anyone tell me what I am doing wrong??

[outthere]

OK so I did some more research and got it to this point

Please Login or Register  to view this content.

I get an error in the reference to data.xls

Any ideas???