In this guide, you will learn how to do use an ARRAYFORMULA with a VLOOKUP in Google Sheets,
How to Perform VLOOKUP as an ArrayFormula in Google Sheets
Here’s our step-by-step guide on how to perform vlookup as an arrayformula in Google Sheets.
Step 1
First, select an empty cell and begin typing the ARRAYFORMULA function.
In this example, we’ll use the ARRAYFORMULA to add a formula in cell B2 that performs a VLOOKUP for each transaction ID in the range A2:A8.
Step 2
Inside the ARRAYFORMULA, set up the VLOOKUP formula and write the range of lookup values as the first argument.
Step 3
Next, indicate the range of the lookup table, the column to output, and the type of matching to use.
In our example, we’ll use the lookup table in range E2:F101.
Step 4
After hitting Enter, all rows should now have the appropriate value filled in. With the ARRAYFORMULA, we can perform a VLOOKUP on a range of values using only a single formula.
Summary
This guide should be everything you need to learn how to use the ARRAYFORMULA with VLOOKUP in Google Sheets.
You may make a copy of this example spreadsheet to test it out on your own.