Author: Oscar Cronquist Article last updated on February 19, 2018

Question: Does anyone know how to do a VLOOKUP of three columns to pull a single record?

Answer:

Array formula in B17 using named ranges:

=INDEX($B$3:$F$11,MATCH(1, COUNTIFS($B$14, $B$3:$B$11, $C$14, $D$3:$D$11, $D$14, $E$3:$E$11), 0), COLUMNS($A$1:A1))

To enter an array formula, type the formula in a cell then press and hold CTRL + SHIFT simultaneously, now press Enter once. Release all keys.

The formula bar now shows the formula with a beginning and ending curly bracket telling you that you entered the formula successfully. Don't enter the curly brackets yourself.

Download Excel *.xlsx file

vlookup of three columns to pull a single record.xlsx