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

Advertisements

A

Arvi Laanemets

Hi

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

Advertisements

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top