Hi Roly,

i apologize i think i misunderstood you in my last reply 9/12th. Go ahead &
give me the vlookup formula that will return the matched values without
duplications. Please let me know if you have any questions. Thank you!
--
biz


"roly" wrote:


Hi Biz,

I can get this but it will give duplicates in column C - I have the
feeling that you do not want this so is there a minimum to maximum
range of number? This will enable us to use a separte column as
criteria, which will only show the values that are equal once.

If not, let me know.

All the best,


Roly


--
roly
------------------------------------------------------------------------
roly's Profile: http://www.excelforum.com/member.php...o&userid=24631
View this thread: http://www.excelforum.com/showthread...hreadid=401194