Assuming that the entries in column 1 are unique (no duplicates)

I would sort the data in column 1

Copy the data from column2 and 3 else where

I may then sort although it is not necessary

Then use a vlookup for column 2 it is enclosed in the if statement to
avoid #N/A being returend

=IF(ISNA(VLOOKUP(a2,$G$2:$H$100,1,0)),"",VLOOKUP(E 8,$G$2:$H$100,1,0))

Assuming the data to match is in cells g2:h100 adjust accordingly

Then for column 3

=IF(ISNA(VLOOKUP(a2,$G$2:$H$100,2,0)),"",VLOOKUP(E 8,$G$2:$H$100,2,0))

Regards

Dav


--
Dav
------------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=507647