Good afternoon:

Looking for a way to take data from one spreadsheet, compare it with
another, if there's a match by cell from both spreadsheets, take both rows
and combine it into one row on a new spreadsheet or something similar.

I'm working with column O on one spreadsheet and column E on another. For
example, if 'O36' on sheet 1 matches with 'E412' from sheet 2, take both rows
of information and add it to the new sheet.

Is something like this possible?

thanks, as always for the great assistance here.