lezawang
Well-known Member
- Joined
- Mar 27, 2016
- Messages
- 1,805
- Office Version
- 2016
- Platform
- Windows
Hi
I just noticed that excel will lock a range if the range was selected from different file but if the range was selected from different sheet then excel would not lock it. What is behind that?
I am using vlookup
=vlookup(A1,sheet2!B2:D10,2,false) <<--- from different sheet, same file
=VLOOKUP(A1,[testing1.xlsx]Sheet1!$B$2:$D$10,2,FALSE) <<---- from different file
I just noticed that excel will lock a range if the range was selected from different file but if the range was selected from different sheet then excel would not lock it. What is behind that?
I am using vlookup
=vlookup(A1,sheet2!B2:D10,2,false) <<--- from different sheet, same file
=VLOOKUP(A1,[testing1.xlsx]Sheet1!$B$2:$D$10,2,FALSE) <<---- from different file
