I have used the index / match formula similar to below but it only returns
the first instance of the match, is there a way of having all the items
listed in column A that matches the criteria rather than just the first one
it comes across.

Thoughts were that on a seperate worksheet I copied the formula down to row
100, each formula starting at the row number it was actually in, this would
give me a list that meets the criteria (with duplicate names) but how would
I copy this this back to my original worksheet without the duplicate names.

=INDEX(Sheet2!A1:A100,MATCH(1,(Sheet2!B1:B100"3") *(Sheet2!C1:C100=1234),0))

Many thanks
Mick