Linking cells

[Sykamo]

I know how to link a cell to a workbook; however, the cell I want the information from is part of a table that can be rearranged from A to Z or a different column’s entry, etc. so when the information moves, the cell I linked changes to whatever new information is now in that specific cell instead of following where it has been sorted. How do I link it so it follows the info and not the exact cell?
TIA!

 

[Jeffrey Mahoney]

Use a formula, either a vlookup, xlookup, sumif on the range you have your data. There must be a key field or two you can use to get the exact value you need.