You can do a lot in Microsoft Excel and Google Sheets, beyond the obvious spreadsheet-style organization and data collating. A lot of this is tied to both of their programming-like functions that can ...
VLOOKUP searches for a value in the first column of a range and returns a value in the same row from a specified column.