Hi Allan,
I would use a helper column in sheet 2, say C, insert
=IF(ISERROR(MATCH(B2,Sheet1!A:A,0)),0,MATCH(B2,She et1!A:A,0))

in C2, drag down to row 524, and filter column C 0!

Regards,
Stefi

€žallanbugg€� ezt Ã*rta:


Hi,

I have a workbook with two sheets.

In Sheet 1, Column A there is a list of values approx. 524

In Sheet 2, Column B I have another list of values.

How do I filter to only show rows on sheet 2 if the value in column b
appears in the list of values in column A on sheet 1?

Any help would be appreciated.

Thanks,

Allan Bugg


--
allanbugg
------------------------------------------------------------------------
allanbugg's Profile: http://www.excelforum.com/member.php...o&userid=35847
View this thread: http://www.excelforum.com/showthread...hreadid=556383