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.

=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.

Bernard, thanks for replying. I think we're sorta on the right track and
yes, by 'match' i meant equal.

Each sheet has several columns of information. One common column from both
sheets is E from Sheet 1 and O from Sheet 2. I'd like something that will
look for all the occurences where a cell in column E from Sheet 1 matches a
cell from column O from sheet 2, copy the entire row from each sheet and
paste it to a new sheet on one row.

Additional info - sheet 1 may have around 500-1000 rows while sheet 2 will
have around 4-5 thousand rows. there might only be 100 rows that match
between the two sheets (sheet1 Column E, sheet2 Column O).

Hope i didn't make this more confusing.

thanks again!




"Bernard Liengme" wrote:

=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.