Previous Topic Next Topic

Compare 2 columns choose answer in third

Closed
John - Aug 27, 2015 at 11:35 AM
xpcman Posts 19530 Registration date Wednesday October 8, 2008 Status Contributor Last seen June 15, 2019 - Aug 27, 2015 at 07:29 PM
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).
Related:

1 response

Answer 1 / 1
xpcman Posts 19530 Registration date Wednesday October 8, 2008 Status Contributor Last seen June 15, 2019 1,825
Aug 27, 2015 at 07:29 PM
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
0