How to compare two columns in Google Sheets

Google Sheets is a cloud-based spreadsheet application developed by Google. Users can create and edit spreadsheets online, and can also collaborate in real-time with other users while creating and editing spreadsheets. Some of its key features and functions include: editing and sharing spreadsheets, sorting and filtering data, formula creation and execution, data visualization, and many … Read more

You can watch a video tutorial here. In Google Sheets, this can be done using the VLOOKUP() function.   In this example, we will use VLOOKUP() to find names in the first column that match those in the second column.