try this,
cell address will be shown.

Sub match_it()
Dim i As Integer
Rng = Cells(Rows.Count, "A").End(xlUp).Row

For i = 1 To Rng
If Cells(i, "A") = "raju" And Cells(i, "D") = "" Then
MsgBox Cells(i, "D").Address
End If
Next
End Sub


On Apr 2, 2:51*pm, "tkraju via OfficeKB.com" <u16627@uwe 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.comhttp://www.officekb.com/Uwe/Forums.aspx/excel-programming/200904/1