It is still not clear what you require

In the small sheet you are trying to make a match with the master
sheet

Firstly are all the rows unique in the master sheet eg each name only
appears once and you wish to return this information to the small
sheet

or do you wish to return all the rows matching the row in the small
sheet?

Give a small example say 3lines in the small sheet and 10 lines in the
Master sheet (you do not need to list all the columns!) and describe
what you wish to happen

Regards

Dav


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