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:
Can anyone tell me what I am doing wrong??
Function getcount(Code) getcount = VLookup(Code,'\\FileServer\SubFolder\[name.xlsx]WorkSheet'!$A:$K,4,FALSE) End Function
Last edited by Leith Ross; 03-18-2009 at 02:27 PM. Reason: Added Code Tags
OK so I did some more research and got it to this point
I get an error in the reference to data.xlsFunction getcount(Code) getcount = WorksheetFunction.VLookup(Code,'[\\Server\Lists\Data.xlsx]Codes'!$A:$K, 4, False) End Function
Any ideas???
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks