+ Reply to Thread
Results 1 to 3 of 3

VLOOKUP On-Line [OneDrive]

  1. #1
    Registered User
    Join Date
    05-08-2019
    Location
    St. Louis, Missouri, USA
    MS-Off Ver
    Office 365 ProPlus
    Posts
    4

    VLOOKUP On-Line [OneDrive]

    Use vlookup all the time in Excel [local], but can't figure out how to make it work in Excel on-line [OneDrive].

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,377

    Re: VLOOKUP On-Line [OneDrive]

    It works in exactly the same way. What is the problem you are having, specifically?
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  3. #3
    Registered User
    Join Date
    05-08-2019
    Location
    St. Louis, Missouri, USA
    MS-Off Ver
    Office 365 ProPlus
    Posts
    4

    Re: VLOOKUP On-Line [OneDrive]

    You are correct that the formula works exactly the same way when both worksheets are in the same workbook.

    I'm using worksheets in two different workbooks (call them Book1 [where the formula goes] and Book2 [where the table array is]). In normal Excel this is easy, just use the format =vlookup(RefCell,[Book2]Sheet1!startpoint:endpoint,2).

    But, I'm using OneDrive. I own both of spreadsheets, they're in the same OneDrive folder, and are both open at the same time. The problem with OneDrive is that I can't figure out how to make the [Book2]Sheet1! part work. Normally you just click off to the other workbook (Book2), highlight the range, add a comma, and it jumps back to the formula so you can add the other arguments. Doesn't work that way in OneDrive. I don't know how to reference Book2.
    Last edited by andyrwise; 02-12-2020 at 06:56 PM.

+ 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] OneDrive URL location
    By sungen99 in forum Office 365
    Replies: 2
    Last Post: 12-13-2019, 02:29 AM
  2. [SOLVED] VLOOKUP Refence to a OneDrive Table
    By Archichuk in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 03-14-2019, 10:46 AM
  3. Replies: 1
    Last Post: 03-12-2019, 04:32 PM
  4. OneDrive Integration
    By Donov in forum Excel General
    Replies: 1
    Last Post: 10-17-2018, 05:10 AM
  5. Saving on OneDrive
    By plans in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-15-2017, 05:05 PM
  6. Excel to onedrive to webpages
    By blacktrek in forum Excel General
    Replies: 0
    Last Post: 07-06-2015, 01:37 PM
  7. VBA for files in OneDrive
    By bleeding_me in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-01-2014, 11:21 AM

Tags for this Thread

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