PDA

View Full Version : Working two worksheets into a third worksheet



rudy1
08-02-2007, 12:03 PM
Hi,

I have two worksheets in the same workbook with relatively the same data. They each have two very long columns of info.

I have a third worksheet that I would like to filter the info from the first two worksheets into. I would like the info that does not match in the first two worksheets to be displayed in the third.

Any suggestions would be much appreciated.

stanleydgrom
08-02-2007, 04:22 PM
rudy1,

You could use VLOOKUP in each of the first two sheets looking at the data in the each other.

Those VLOOKUP formulas, in both of the first two sheets, that display '#N/A', are not in each other.

You could then filter the data in each of the first two sheets on '#N/A', and copy the data to the third worksheet.

Have a great day,
Stan