You dont need a macro to find this. Use this formula in col E

=IF(AND(A1="raju",D1=""),"BLANK","")
--
If this post helps click Yes
---------------
Jacob Skaria


"tkraju via OfficeKB.com" wrote:

my W/sheet data is;

Col A ---------- Col B-------------Col C ---------------Col D
raju -------------- 1234-----------------5678-----------------90
david------------- 098-------------------765-------------------432
raju-------------- 32----------------------76-------------------
james------------567--------------------uyt-----------------980
david---------------67-------------------567-----------------
I need a code -- match 'raju' from Column A and find which cell in Col D is
empty against 'raju'

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200904/1