News, tips, advice, support for Windows, Office, PCs & more. Tech help. No bull. We're community supported by donations from our Plus Members, and proud of it
Home icon Home icon Home icon Email icon RSS icon
  • How do I call a file for a vlookup that resides on my company server

    Posted on WSncordero33 Comment on the AskWoody Lounge

    Home Forums AskWoody support Microsoft Office by version How do I call a file for a vlookup that resides on my company server

    Viewing 1 reply thread
    • Author
      Posts
      • #2284144 Reply
        WSncordero33
        AskWoody Lounger

        Hi,
        I am trying to reference a file on the shared folder and the formula is only working when I have the file open.  How can I do a vlookup to a file that is on the shared folder but not open?  See my formula below.
        Thank you in advance!
        =IFERROR(INDEX(‘\\testdomain.com\SSSS\Interfaces\Prod\HR AUTOMATED REPORTS\HR DATA\WORK\test.xlsx’!$A$1:$AP$2141,SMALL(IF(COUNTIF($C$11,’\\testdomain.com\SSSS\Interfaces\Prod\HR AUTOMATED REPORTS\HR DATA\WORK\test.xlsx’!””)

      • #2284168 Reply
        Paul T
        AskWoody MVP

        What version of Office?

        cheers, Paul

    Viewing 1 reply thread

    Please follow the -Lounge Rules- no personal attacks, no swearing, and politics/religion are relegated to the Rants forum.

    Reply To: How do I call a file for a vlookup that resides on my company server

    You can use BBCodes to format your content.
    Your account can't use Advanced BBCodes, they will be stripped before saving.