Matching First and second names and zip codes with ID numbers in two different sheets

Hi

I am new but really need help. I need to match a list of names with there ID number. The list of names is small only about 200 but the ID is is about 6000.

The fist list has a First and second name a zip code and other bit's of information that I need to have the ID to be able to imput it but it doesn't have that ID number

F Name	L Name	Zip Code	Email	Info
paul	swain	kt10 9ij	[email protected]	works at home
Jo	bloggs	ls3 5th	[email protected]	some info
Rich	roper	ba34 613	[email protected]	works from home

The list of ID's has First and second name a zip code and the ID code but dosn't have the information on it that I need and isn't in the same order.

F Name	L Name	Zip Code	ID
James	jones	kt23 8uu	1001
other	name	zp1 o11	1002
other	name 2	zp2 o11	1003
other	name3	zp1 5rr	1004
paul	swain	kt10 9ij	1005
other	name6	zp1 o11	1006
other	name 7	zp2 o11	1007
other	name 66	zp1 o11	1008
other	name 70	zp2 o11	1009
Jo	bloggs	ls3 5th	1010
Rich	roper	ba34 613	1011

My question is - is there a script I can use that will match the First and second name and post on the ID list and then move the ID code onto a separate column?

so i end up with this:

F Name	L Name	Zip Code	Email	Info	ID
paul	swain	kt10 9ij	[email protected]	works at home	1005
Jo	bloggs	ls3 5th	[email protected]	some info	1010
Rich	roper	ba34 613	[email protected]	works from home	1011

hope that makes sense


Thanks!

1 - Next to your first list you need to make a "helper" column by combining the First name, last name and zip code (=A1&B1&C1). Let's call it column F:F.
2 - Copy and Paste Special Values over the formula.
3 - Repeat step 1 & 2 for the other list that has the ID's. Insert this "helper" column to the immediate left of the ID column. Let's call it column C:C
4 - Next to the helper column in the first list, put this formula in and copy down =VLOOKUP(F1,List2!$C$1:$C$5000,2,FALSE)

Please upload your spreadsheet with any sensitive data removed (Go Advanced-->Manage Attachments) if this wasn't helpful. It's easier for us when we have a file to play with.

Hi and welcome to the forum

Craig is spot-on with step 1, but you can leave the formula there

and to extract the data you need, you can use this variation. Assuming your 2 tables are on sheet1 and sheet2 (adjust references as needed)...
=index(sheet1!$A$1:$E$200,match(A2&B2&C2,sheet1!$F$1:$F$200,0),match(E$1,sheet1!$A$1:$E$1,0))
copied down

Please see the attached file. The columns in yellow on the first tab contain the formulas you need. Be sure to update the formulas with the correct tab names.

paulnrswain solution.xls

Thanks for the file, and no, your sheets are not that complex, and what I suggested will work - you just need to adjust the references....
for the helper column in sheet2, copied down...
=C2&B2&H2
you will need to use the same principle for sheet1 too

Then to pull in the info on sheet3...
=INDEX('ID NO INFO'!$A$1:$H$500,MATCH('OUT PUT I want '!$C2&'OUT PUT I want '!$B2&'OUT PUT I want '!$D2,'ID NO INFO'!$I$1:$I$500,0),MATCH('OUT PUT I want '!A$1,'ID NO INFO'!$A$1:$H$1,0))
Copy this down, and then adjust the references sheet1 for those columns that you need from that sheet