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.

Basic Array Formula: Use the ARRAYFORMULA function to apply a formula to an entire range. For example, =ARRAYFORMULA(A1:A10 * B1:B10) multiplies the corresponding values in columns A and B for ...

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.