I didn't think about essentially doing both operations in one. That is a
great idea! Thank you!
Lisa

"Duke Carey" wrote:

if your lookup range contains

Row# ColA ColB
1 Name Student#
2 Carey, Duke 897
3 Doe, Lisa 1022

and you have the text Doe in cell C6 and the text Lisa in D6,use

=VLOOKUP(C6&", "&D6,A2:B3,2,0)


"Lisa" wrote:

On the destination sheet I have a column that has first and last names that
have been joined by concantenating them. On the reference sheet, the cells
contain the same first and last name (the matching column) but they have been
exported from a system and did not need to be concatenated. I know that the
vlookup formula is correct because if I type over the concatenated cell the
actual first and last name, It will then reference the student number (The
infomration that I am trying to bring over to the destination sheet.)
So I guess my uqestion is how do I make data that has been concatenated into
text.
"Duke Carey" wrote:

Yes.

Would you like to describe what you're trying to do, so that you can get a
more helpful answer?

"Lisa" wrote:

Can you base a vlookup formula on data that has been concatenated?