I only recently discovered this function, and it’s been a lifesaver. I work in construction, going through big tables that outline all the doors in the project, and every once in awhile they put out an addendum that completely changes the order all the doors are listed in, adding new ones and changing bits and pieces along the way. It used to take me hours or even days of sorting to salvage the work I put in, getting it reorganized to fit the new table in the crappy construction spreadsheet program we have. Now I can just copy everything to excel, use vlookup, and reorder all my data to the new table in minutes!