Ask Your Question

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

asked 2013-09-23 15:11:22 +0100

tonysch gravatar image

updated 2013-09-23 15:57:50 +0100

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. :)


edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2015-11-09 11:21:04.404519

1 Answer

Sort by » oldest newest most voted

answered 2013-09-23 22:45:19 +0100

m.a.riosv gravatar image

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.


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

edit flag offensive delete link more


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


tonysch gravatar imagetonysch ( 2013-09-24 14:57:45 +0100 )edit

Question Tools

1 follower


Asked: 2013-09-23 15:11:22 +0100

Seen: 527 times

Last updated: Sep 23 '13