Forum Discussion
ohadeini
Jun 10, 2020Copper Contributor
Exel
How do I keep referencing content in the cell even after sorting?
mtarler
Jun 10, 2020Silver Contributor
ohadeini as already noted by others and noticed by you, you don't want to just link to a cell location since the values will move but that cell location will stay there. Instead you should use a unique id for that row (or add one if needed) and then use the VLOOKUP function to get the value you want. If you need an example we can make one or you can send your workbook because then we might find additional tips that might be helpful.