Vlookup with OneDrive not working

[AWiseGuy]

My question is: I use VLOOKUP all the time in Excel and am very good at it. I am being forced to start using Excel on-line with OneDrive and, major issues. I can’t figure out how to reference the Table_Array. I have two spreadsheets, Book1 [where the formula will go] and Book2 [where the Table_Array is]. I own both, they are in the same OneDrive folder, and they are both open on my computer.

Formula of =Vlookup(B1,[Book2.xls]Sheet1!$A$1:$B$5) works perfectly in normal Excel. Then I copied them to my OneDrive. Can’t figure out the formula (how to reference the TableArray) for OneDrive.

Book1​
​	A​	B​
1​		Apples
2​		Oranges
3​		Bananas
4​		Grapes

Book2​
​	A​	B​
1​	Bananas	12​
2​	Oranges	31​
3​	Apples	24​
4​	Grapes	9​
5​	Pears	15​

 

[Dave Patton]

Your formula is not complete.

Book1
	B	C
1	Oranges	31
2	Pears	15
1a

Cell Formulas
Range	Formula
C1:C2	C1	=VLOOKUP(B1,[Book2.xlsm]Sheet1!$A$1:$B$5,2,0)

When you build the formula, you could type the first part and then move to the other workbook and select the range that includes the Table.
Then complete the formula.

 

[AWiseGuy]

Granted I didn't finish the formula.

The problem is that with OneDrive when you move to the other workbook the formula doesn't reflect it.

I use vlookup in Excel all the time. You need to try it in OneDrive to understand the difference in functionality.

 

[Dave Patton]

The example that I posted was for the 2 files stored in OneDrive.
Excel works as normal.