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?