One thing to be careful with Excel is VLOOKUPs and Sorting.
If you have a column that you’ve used to create a VLOOKUP, and then you try to sort on that column, you’re going to see some wonkiness.
The sort will change the VLOOKUP, which will use different values for the sort.
Your best bet in this situation is to copy the values of the VLOOKUP column, then sort by that column.
© 2025 Return on Development, Seth Hayward