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...
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.