vlookup-basic

kweisser

New Member
Joined
Jul 7, 2008
Messages
17
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?
 

Excel Facts

Create a chart in one keystroke
Select the data and press Alt+F1 to insert a default chart. You can change the default chart to any chart type

Jonmo1

MrExcel MVP
Joined
Oct 12, 2006
Messages
44,061
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 ?
 
Upvote 0

kweisser

New Member
Joined
Jul 7, 2008
Messages
17
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.
 
Upvote 0

Jonmo1

MrExcel MVP
Joined
Oct 12, 2006
Messages
44,061
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...
 
Upvote 0

VBANoob

New Member
Joined
Jul 7, 2008
Messages
1
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.
 
Upvote 0

Kaps_mr2

Well-known Member
Joined
Jul 5, 2008
Messages
1,546
Concatenation is the best way of doing is Col C = Col A & Col B. and then look up on Col C. Thanks

Kaps
 
Upvote 0

Forum statistics

Threads
1,191,671
Messages
5,987,957
Members
440,121
Latest member
eravella

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top