Forum Discussion
Riny_van_Eekelen
Oct 04, 2022Platinum Contributor
Re: Linking cells in one worksheet to another that can be sorted
James_Stallcup you should use the XLOOKUP (since you tagged Office365) for that. See example in the attached workbook.
2 Replies
- DFI_SandiCopper Contributor
Thank you so much for sharing this example file! I've muddled through my own spreadsheet using your example and figured out how to link data that can be sorted afterwards. This is the first time I've actually understood how to do this with XLOOKUP.
- James_StallcupCopper ContributorThanks. I did.