Ooh ooh, me sir!

Use =VLOOKUP.

It'll be along the lines of =VLOOKUP(sheet2!A2, $sheet1!$a$2:$sheet1$!a$1001,)

Your lookup range has to be ordered sequentially I think and there's a 0/1 option after the second comma in the formula and I forget which one.

The dollars fix your reference range so it doesn't try and increment that when you copy down.

I think it returns a 1 if it's found. You then filter that column by 1, voila, your list of records in the other list.

Get it?

Posted By: trafford_canary, Jul 29, 16:15:00