Calc - How to search for an data on another sheet then copy multiple rows of data to first sheet

Hello,
Here is what I have. There is one spreadsheet with 2 sheets. One sheet 1 I have names and email addresses from a csv output on newsletter system. On sheet 2 I have hundreds of lines from a customer search engine (name, company, email, etc).
What I am trying to do is take the email list from sheet one. Search sheet 2, if it finds the same email address, then copy over (company name, address, position, phone number, etc).
I have been searching for days and still having problems finding a formula that will work.

Any help would be greatly appreciated. :slight_smile:

Tony

Attached a sample file for doing with INDIRECT() or OFFSET() used as arrays with all data row in one formula, or using OFFSET() column by column. Another useful function is VLOOKUP() but there is problem if the column for search is not the first one.

CombineTwoTablesByOneColumn.jpg

Please change the file extension to ods,
seem there is an issue to upload files that have not a graphic file extension.

Thanks Mariosv. Changed the extension to ods. I am able to see the data, but the functions are gone.

Tony