You can use VLOOKUP with Google Sheets similar to how the search function is used to find information in Excel.

How to Use a VLookup in Excel 2003 to Reference the Data in a CSV. Microsoft Excel's VLOOKUP function fetches data from different cells. It searches an array for a specific value and returns the ...

This is easily one of the handiest ways to sort through and understand large reams of data.