Vlookup and arrays

redrickst

New Member
Joined
Jan 25, 2023
Messages
2
Office Version
  1. 365
Platform
  1. Windows
Hi, I created a spreadheet that pulls in data from other sheets with Vlookup. I worked with it at home -cut, copied, deleted rows with no problem, saved it, sent it in to the office, I worked with it fine. However, today, as I wanted to edit the spreadsheet in the office, excell started to throw me the "you cannot edit part of an array" message, and wasn't willing to pull in certain data. The Vlookup formula also got enclosed in curly brackets. I came home, opened the same file and the error was gone, it was working like before. It also works on my phone, and on my macbook. What made it stop working on my office computer?
 

Excel Facts

Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.
Perhaps you created the sheet with O365 and opened it in another version?
 
Upvote 0
Perhaps you created the sheet with O365 and opened it in another version?
I'll check the office versions today, though it doesn't explain why it was working fine a week ago no matter where I used them and there wasn't an office upgrade at the office.
 
Upvote 0

Forum statistics

Threads
1,213,559
Messages
6,114,302
Members
448,564
Latest member
ED38

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top