Help!!! Trying to combine three columns from each spreadsheet into one master

Hello,

i m trying to figure out what the best formula would be to add the date of the last three columns of each spreadsheet i have onto one master spreadsheet.

For example i want to add the data from columns d, e, and f from spreadsheet "part 1" and include them in my spreadsheet called "combo", there are a total of four parts and i need the last three columns of each spreadsheet and i am matching them by using the email or address columns.

Attached is the file.

I need to finish this today, it is my last day on the job

thank you excel angels!!!!

Emmy

Moderators note: attached file removed at OP's request

Perhaps this link will help

We really would need the sample sheet to work on...

Hi Emmy!

I've added helper columns to each tab where I've combined the first name and last name, so the lookup happens for the combination.
I've also put in the formulas you need for the Purex and Dry Idea part of the Combo tab.

Don't forget to click the little star to the left of this post if you feel I helped!