+ Reply to Thread
Results 1 to 2 of 2

Offset function with nested match function not finding host ss.

  1. #1
    MKunert
    Guest

    Offset function with nested match function not finding host ss.

    I have an offset function with a nested match function that looks to a
    separate spreadsheet. If I have both spreadsheets open, it works fine. If
    the host ss is not open, I get a #VALUE! error. The vlookups on the sheet
    look to the same host spreadsheet, and they are not affected. Any ideas?

  2. #2
    Peo Sjoblom
    Guest

    Re: Offset function with nested match function not finding host ss.

    That's the way it is, OFFSET does not work with closed workbooks, if you can
    replace with index and match it will work


    Regards,

    Peo Sjoblom


    "MKunert" <[email protected]> wrote in message
    news:[email protected]...
    >I have an offset function with a nested match function that looks to a
    > separate spreadsheet. If I have both spreadsheets open, it works fine.
    > If
    > the host ss is not open, I get a #VALUE! error. The vlookups on the sheet
    > look to the same host spreadsheet, and they are not affected. Any ideas?




+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1