Thanks, that's very helpful and works well but I've now been asked to do
something else with this data which means I now need to do the following
and extract the whole row for matching records.

I need to return the whole row from Sheet1!A2:N16428 based on Sheet1
column A values matching any of the values listed in Sheet2!A2:A2015.
Sheet2!A2:A2015 contains values which may occur multiple times in
Sheet1!A2:A16428 and I need to extract all rows which match

Please help.

Many thanks


--
alexdwsn01
------------------------------------------------------------------------
alexdwsn01's Profile: http://www.excelforum.com/member.php...o&userid=35250
View this thread: http://www.excelforum.com/showthread...hreadid=550153