Reconstruct data after sorting error

**coloradoangel** · 06-05-2014, 08:47 AM

I am new on here and I would say that I am a little more dangerous on Excel than the average user... however, I screwed up. I have been working on a spreadsheet with 28000 lines and I have gone through and resorted, researched and completed the spreadsheet over the last couple weeks. When I went to change it back to a CSV file to give back to the vendor, I realized that at some point when I sorted the list I mixed up the unique identifier (I at some point did not sort the UID only the other columns) and because I have resaved this file over itself I only have the original CSV file to go back and reimport... but dont have time to look up each of these 28000 lines again. Can someone help please? I am looking for a way to take a cell from my final spreadsheet (Spreadsheet A) then find it on the original CSV spreadsheet (Spreadsheet B) then copy the UID field from speardsheet B to a blank field in spreadsheet A.

**Pete_UK** · 06-05-2014, 08:58 AM

You will need to choose a field which has unique values, and then with both files open you will be able to use an INDEX/MATCH formula or a VLOOKUP formula (depending on how your data is laid out). Post sample workbooks if you want further details.

Hope this helps.

Pete

**6StringJazzer** · 06-05-2014, 08:50 PM

Originally Posted by Pete_UK

You will need to choose a field which has unique values...

...or a combination of fields that together are unique. In any case, Pete is right, we need more information specific to your data, ideally your actual files.