=IF('Sheet1'!O36='Sheet2'!E412,'Sheet1'!O36,"")
if the two cells are equal (is this what you mean by "match") then the cell
with this formula will display the value of the cells, otherwise it will
display blank (a pair of double-quotes with nothing between them results is
a blank display.
Tell us if this is close to your need; or please expand on what is required.
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email


"Versace77" wrote in message
...
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.