Compare 2 columns choose answer in third

[Closed]
Report
-
Posts
19532
Registration date
Wednesday October 8, 2008
Status
Contributor
Last seen
June 15, 2019
-
Hi all,

First of all thank you for reviewing this.

I have a data dump from a survey. Column A shows the survey #. On other sheet (sheet1) I have survey results to the questions with the survey #. I would like to compare data dump!A:A to Sheet1!A:A. If the two are equal I would like to dump the contents of Sheet1! row B in line with that survey# to Data dump B:B.

The data in sheet 1 is horizontal results from the survey. Survey #123 with all information across

The Sheet1 has formatted the data vertically so I have survey #123 listed 10 times (once for each survey question).

1 reply

Posts
19532
Registration date
Wednesday October 8, 2008
Status
Contributor
Last seen
June 15, 2019
1,858
This is the point where you hire a programmer to write the code for you. Or you spend the next two months learning to program.

Good luck

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!