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,941
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