Thanks Tom,

However, this gives the result only if it exists in the same row and
also I was looking for VB as I see that this is very time consuming and
it has taken almost 10 min and is still calculating. Is there any other
way out......

Regards,
Praveen


--
praveen_khm
------------------------------------------------------------------------
praveen_khm's Profile: http://www.excelforum.com/member.php...o&userid=30364
View this thread: http://www.excelforum.com/showthread...hreadid=526091