# VLOOKUP Function and data combined from 2 cells

G

#### Guest

I am trying to use the VLOOKUP function to lookup and return the combined
value of 2 separate cells. Specifically, I want to use the VLOOKUP function
the VLOOKUP function to return the combined value of cells \$Z2 (First Name)
and \$AA2 (Last Name). I used the following formula for other cells that
referenced only a single cell in the "Master" worksheet:

=VLOOKUP(\$A4,'MASTER REGISTRATION LIST'!\$1:\$65536,5,FALSE)

Is this possible to use this formula and return the combined value of 2
cells ? If so, how?

A

#### Arvi Laanemets

Hi

Something like
=VLOOKUP(\$A4,'MASTER REGISTRATION LIST'!\$1:\$65536,5,FALSE) & " " &
VLOOKUP(\$A4,'MASTER REGISTRATION LIST'!\$1:\$65536,6,FALSE)

G

#### Guest

Thanks for your reply. However, that's not exactly what I'm looking to do.
Actually, I need the VLOOKUP to lookup 2 different values. Specifically,
when doing the lookup, I need it to look up both the Last Name (\$A2) and
First Name (\$B2) and then yield the result. So essentially, I use the
formula you suggested but replace the reference values as such:

=VLOOKUP(\$A4,'MASTER REGISTRATION LIST'!\$1:\$65536,5,FALSE) & " " &
VLOOKUP(\$B4,'MASTER REGISTRATION LIST'!\$1:\$65536,5,FALSE)

Thanks so much!