I have two columns of data, the first column contains a reference, and
the second contains the data, I want to be able to find data in the
second column where the value in the first column matches a given
reference. I can do this if the reference is unique in the first
column, however the same reference may occur several times in the first
column and I want to be abnle to return all values that match not just
the first one.

Thank you in advance for your assistance in this matter.


--
JHalsall
------------------------------------------------------------------------
JHalsall's Profile: http://www.excelforum.com/member.php...o&userid=34382
View this thread: http://www.excelforum.com/showthread...hreadid=555480