Home

change positions

Highlighted
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

 

 

thanks

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

@Twifoo 

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

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

can you give me an example?

 

tks

Highlighted
You have to attach your sample file.
Highlighted

@Twifoo 

 

 

Highlighted
Your formula in Sheet1!A1, copied down the rows, should look like this:
=VLOOKUP(A1,
Sheet2!A:B,
2,0)