Many many thanks for your time and assistance to you both.
It worked well, I even added another criteria to the formula (but did not
chnage anything else ie row numbers) and that worked as well.

Thanks again
Mick

"Teethless mama" wrote in message
...
=IF(ISERR(SMALL(IF((Sheet2!$B$1:$B$1003)*(Sheet2! $C$1:$C$100=1234),ROW(INDIRECT("1:"&ROWS(Sheet2!$C $1:$C$100)))),ROWS($1:1))),"",INDEX(Sheet2!$A$1:$A $100,SMALL(IF((Sheet2!$B$1:$B$1003)*(Sheet2!$C$1: $C$100=1234),ROW(INDIRECT("1:"&ROWS(Sheet2!$C$1:$C $100)))),ROWS($1:1))))

ctrl+shift+enter (not just enter)
Copy down as far as needed


"Mick" wrote:

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