VLOOKUP Function and data combined from 2 cells

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

MsBeverlee - 20 Feb 2007 06:16 GMT

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?

Reply to this Message

Arvi Laanemets - 20 Feb 2007 06:38 GMT

Hi

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

Signature

Arvi Laanemets
( My real mail address: arvi.laanemets<at>tarkon.ee )

>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
[quoted text clipped - 8 lines]
> Is this possible to use this formula and return the combined value of 2
> cells ? If so, how?

Reply to this Message

MsBeverlee - 11 Mar 2007 23:06 GMT

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!

> Hi
>
[quoted text clipped - 14 lines]
> > Is this possible to use this formula and return the combined value of 2
> > cells ? If so, how?

Reply to this Message