compare two columns and extract the information

[Sheepkin_Coat]

Hi

I have a project where i have 2 spreadsheets with clients names on and i want to compare both sheets and see if the same names appear on both sheets and if so i then want to get the information from sheet 1 into another sheet.

So sheet 1 has the following information

Cell E - First Name
Cell G - Surname
Cell AO - First line of address
Cell AP - Second line of address
Cell AQ - Third line of address
Cell AS - Postcode
Cell AT - Contact Number 1
Cell AU - Contact Number 2
Cell AV - Email.
and a few other info i need to take and put into a spreadsheet in a certain order.

So the first part of the problem i have is that i need to compare the names from sheet 1 and sheet 2

Sheet 2

Cell B has the clients name on combined.

Can somebody help me with this.

[Sam Capricci]

it sounds like you'll need a couple helper columns for that. For one, if your names appear on sheet2 as First Last, you can combine cells F1 and G1 this way =F1&" "&G1 then using this vlookup =IF(IFERROR(VLOOKUP(AZ1,'Sheet2'!B:B,1,FALSE),"")="","name not in sheet2",VLOOKUP(AZ1,'Sheet2'!B:B,1,FALSE)) this makes assumptions that you put the concatenate in col AZ of sheet1 and your names for comparison are in Sheet2 col B.
(not tested but you can adjust it)