vlookup-basic

[kweisser]

I have two columns (first name, last name) and I need to do a vlookup with both columns to identify the correct individuals. My other report has same column setup with many more rows. I have only done vlookup with one column, how do you do it with two?

 

[Jonmo1]

Welcome to the board...

Will there be only 1 match of first/last name on the 2nd sheet?
What data are you wanting returned with the formula? Text or Number ?

 

[kweisser]

There will only be 1 match of first/last name and I am looking for text returned from the formula. Essentially who one first sheet is a match for second sheet.

 

[Jonmo1]

Well, on the 2nd sheet, I would insert a column to combine the first name and last name into 1 cell..

So say on Sheet2
Col A = First Name
Col B = Last Name
Col C = Data you want to lookup based on first/last name..

Insert a column between b and c, so that the data from C moves to D

In C1 put this formula and fill down
=A1&B1
That will combine the First and last name into one cell in column C

Now your vlookup formula in column C of Sheet1 is
=VLOOKUP(A1&B1,Sheet2!C:D,2,FALSE)

Hope that helps...

 

[VBANoob]

There will only be 1 match of first/last name and I am looking for text returned from the formula. Essentially who one first sheet is a match for second sheet.

Asumming first and last names are in columns A and B, you can combine the two columns using:
=Concatenate(A1,B1)
or
=A1&B1
If you need a space between the names, use:
=A1&" "&B1
That way you can keep it simple and use one vlookup.

 

[Kaps_mr2]

Concatenation is the best way of doing is Col C = Col A & Col B. and then look up on Col C. Thanks

Kaps

 

[kweisser]

thank you-works perfectly!