Need to link data from sheet to sheet? by name and date?

**cstohs0606** · 04-09-2013, 08:33 AM

I'm currently working on a membership database and I have 3 spreadsheets. The 1st includes First Name Last Name Address City Zip Phone Email. 2nd Includes First Name Last Name birthday and anniversary.
3rd includes First Name Last Name current status. I need to create a new sheet that includes all data from each spreadsheet and matches by first name last name in each file.
So final sheet would be:
First Name Last Name Address City Zip Phone Email Birthday Anniversary Current Status.....how do I link all data from 3 seperate spreadsheets into one spread sheet by First Name Last Name?

**Pepe Le Mokko** · 04-09-2013, 08:37 AM

Hi
try using VLOOKUP or an INDEX/MATCH combination

**ChemistB** · 04-09-2013, 08:40 AM

Most efficient way is to create a new column in each sheet (i.e. Insert Col A) and concatenate first and last name there. You can hide that column when you are done.
So in A2 (if row 2 is where your data begins) of Sheet1
=IF(ISTEXT(B2), B2&C2,"") copied down as far as you expect your database to go
Then in your new sheet, you'd copy over columns B and C from sheet1 (into A and B of new sheet)
In C, where you want Address, you'd do a VLOOKUP
=VLOOKUP(A2&B2, sheet1!$A$2:$G500,4, FALSE)
Questions?

Need to link data from sheet to sheet? by name and date?

LinkBack

Thread Tools

Rate This Thread

Display

Need to link data from sheet to sheet? by name and date?

Re: Need to link data from sheet to sheet? by name and date?

Re: Need to link data from sheet to sheet? by name and date?

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions