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

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?

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?

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?

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?

The other thing you might check, if you've imported your data from another
source, is that you don't have "hidden" leading or trailing spaces. That can
really screw up your conatenation (and therefore your VLOOKUP)...

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

Thank you for your help! It now works beautifully!

"BekkiM" wrote:

The other thing you might check, if you've imported your data from another
source, is that you don't have "hidden" leading or trailing spaces. That can
really screw up your conatenation (and therefore your VLOOKUP)...

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