How to Use ARRAYFORMULA with VLOOKUP in Google Sheets

Last Updated on October 31, 2023 by Jake Sheridan

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.