VLOOKUP CONCATENATE – Excel & Google Sheets

Written by

Editorial Team

Reviewed by

Steve Rynearson

Last updated on February 8, 2023
Download Example Workbook

Download the example workbook

This tutorial will demonstrate how to perform a concatenated VLOOKUP in Excel and Google Sheets.

vlookup concatenate main func

VLOOKUP with Concatenation

You may want to perform a VLOOKUP on a data table without unique values in any single column. In the example below, you want to VLOOKUP on First & Last Name.

vlookup concatenate 01

In order to do so, you need to create a helper column that merges first and last name together.


vlookup concatenate 02

In this example, we use the concatenating operator (&), but you could also use the CONCATENATE Function:


Once you have the helper column with distinct values, you can perform an exact match VLOOKUP. To get your lookup value for the formula, use the same concatenation as the helper column.


vlookup concatenate 03



These formulas work the same in Google Sheets as in Excel.

vlookup concatenate Google Function

AI Formula Generator

Try for Free

Excel Practice Worksheet

practice excel worksheet

Practice Excel functions and formulas with our 100% free practice worksheets!

  • Automatically Graded Exercises
  • Learn Excel, Inside Excel!

Free Download

Return to Excel Formulas List