VLOOKUP On-Line [OneDrive]

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

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.