You can use VLOOKUP with Google Sheets similar to how the search function is used to find information in Excel.
You can remove duplicates in Excel in a few steps. Duplicates can create problems when you're dealing with data.