I had an error in my formula have now sorted it.
My formula looks like this:
=INDEX($B:$B,SMALL(IF($A$2:$A$1000=E2,ROW($A$2:$A$ 1000 )),ROW(A1)))
comments on if there is a better way to do this.
Also I now want to be able to see if any of these values contain a
certain value, I am using the below formula which at the moment always
returns F2,
=IF(F$2:F$10="FALSE","FALSE",F2).
--
JHalsall
------------------------------------------------------------------------
JHalsall's Profile:
http://www.excelforum.com/member.php...o&userid=34382
View this thread:
http://www.excelforum.com/showthread...hreadid=555480