Ask Your Question
0

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

Tony

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
0

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.

CombineTwoTablesByOneColumn.jpg

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

Comments

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

Tony

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

Question Tools

1 follower

Stats

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

Seen: 527 times

Last updated: Sep 23 '13