VLOOKUP Function and data combined from 2 cells
 

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?

VLOOKUP Function and data combined from 2 cells
 

Hi

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


--
Arvi Laanemets
( My real mail address: arvi.laanemets<attarkon.ee )



"MsBeverlee" wrote in message
...
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?

VLOOKUP Function and data combined from 2 cells
 

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!


"Arvi Laanemets" wrote:

Hi

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


--
Arvi Laanemets
( My real mail address: arvi.laanemets<attarkon.ee )



"MsBeverlee" wrote in message
...
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?