change positions

New Contributor

I have references on other worksheets that need to change if the references change position.



Sheet 2, B1 is "3"


Sheet 1, D32 is =Sheet2!B1   =3


if i change position of Sheet 2,B1, at example in C1, and the B1 becomes empty, in the cell D32 the value is 0




7 Replies
You should modify your formula in Sheet1!D32 to:
=Sheet2!C1, either manually or moving Sheet2!B1 to Sheet2!C1.


actually this problem borns when i organize sheet 2 in alphabetical order

Instead of directly referencing a specific cell in Sheet2, you should use VLOOKUP or INDEX-MATCH.

can you give me an example?



You have to attach your sample file.




Your formula in Sheet1!A1, copied down the rows, should look like this:
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies