There's one trick, though, that separates the quants from the interns. That trick is Index/Match, a function that can find any value in any spreadsheet.

Google has started rolling out Google Sheets Formula Suggestions which automatically suggests formulas based on the entered data, Here's how you can use them.

There's no wizard in Google Sheets, though, so you'll need to enter all the values manually. How to use VLOOKUP with Google Sheets The easiest way to understand how to use VLOOKUP is with an example.