Vlookup

D

Duke Carey

Yes.

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

Lisa

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.
 
D

Duke Carey

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)
 
B

BekkiM

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)...
 
L

Lisa

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