Forum Discussion
change positions
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 e...
You should modify your formula in Sheet1!D32 to:
=Sheet2!C1, either manually or moving Sheet2!B1 to Sheet2!C1.
=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?
tks
- You have to attach your sample file.