change positions

Copper 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
You should modify your formula in Sheet1!D32 to:
=Sheet2!C1, either manually or moving Sheet2!B1 to Sheet2!C1.

@Twifoo 

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?

 

tks

You have to attach your sample file.

@Twifoo 

 

 

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