Excel - Have 2 workbooks need to combine into 1 w/ conditions

[southbeach]

I have two workbooks. Each have the same columns. I need to create a new workbook extracting all rows where values on two of the columns in workbook1 are same as columns in workbook2.

How is this done?

Thank you all in advance!


--
SouthBeach
The good thing about not knowing is the opportunity to learn - Yours truly, 2008.

 

[SkipVought]

Hi,

I'd use MS Query. Use Data > Import External Data to get the data from each workbook in a separate sheet. Let's say Sheet2 & Sheet3.

Then on Sheet1, join the two using Data > Import External Data to access and join Sheet2 & Sheet3.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}