How to Use ARRAYFORMULA with VLOOKUP in Google Sheets

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.


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.