+ Reply to Thread
Results 1 to 2 of 2

Still Trying to Reference a File On OneDrive With VLOOKUP Statement in An Excel File

  1. #1
    Registered User
    Join Date
    07-11-2018
    Location
    Iowa
    MS-Off Ver
    Office 365
    Posts
    17

    Still Trying to Reference a File On OneDrive With VLOOKUP Statement in An Excel File

    My current VLOOKUP reads as follows:

    =IFERROR(VLOOKUP($A8,'Lot Data'!$A$3:$N$149,5,FALSE)," ")

    In the example above, my form and the worksheet 'Lot Data' are in the same workbook.

    I want to change the reference from 'Lot Data' in the formula above to refer to a worksheet 'Current' in a different workbook on OneDrive at the path below:

    https://onedrive.live.com/edit.aspx?...!111&app=Excel

    Is this possible? If so, what is the syntax?

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,466

    Re: Still Trying to Reference a File On OneDrive With VLOOKUP Statement in An Excel File

    See my response in the old thread: https://www.excelforum.com/excel-pro...ive-table.html
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] File location problems when using OneDrive and Office 365
    By aglawrence in forum Excel General
    Replies: 3
    Last Post: 12-16-2018, 06:39 PM
  2. Excel -- Prevent users from Locking file stored on OneDrive
    By Vinod Krishna.C in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-25-2018, 04:27 AM
  3. Autosave disabled for file on OneDrive (SkyDrive)
    By Tom21g in forum Excel General
    Replies: 1
    Last Post: 11-14-2017, 11:01 AM
  4. Savin file on OneDrive
    By plans in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-01-2017, 03:09 AM
  5. [SOLVED] Auto Backup Excel File in OneDrive
    By LewisJ in forum Excel General
    Replies: 0
    Last Post: 03-31-2017, 10:49 AM
  6. Open 2nd file(CSV) from cell reference, copy columns to main file & close 2nd file
    By Langchop in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-31-2013, 05:09 AM

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