Find multiple values in multiple ranges and produce results in a list

Hi Guys and Gals of Excel Forum, I have an interesting dilemma and I'm not quite sure where to start looking for answers (or even if there is an answer).

I'd like to carry out a find all search for occurrences of a combination of someones surname and post code (columns 12 & 13 respective) in the same worksheet, then for all occurrences of this combination I would like the result value of column 2 to be listed in a separate sheet.

i.e.e
Find = Jones & 18/11/1977

then say we find 4 results the list in another sheet to read

12345
23456
34567
45678

Is this do-able?

Just tried this and it works

Please Login or Register  to view this content.

You Star, adapted for my purposes and works like a charm.

I'd be interested to know how to incorporate an additional search criteria though, say name, DOB and then post code (in that order)?

This is simple but it works

Please Login or Register  to view this content.