VLOOKUP Function and data combined from 2 cells

[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?

 

[Arvi Laanemets]

Hi

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

 

[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!