Fire this macro while in sheet 1
Sub matchiteminothersheet()
On Error Resume Next
For i = 1 To Cells(Rows.Count, "b").End(xlUp).Row
Set x = Sheets("sheet2").Columns("b").Find(Cells(i, "b"), _
LookIn:=xlValues, LookAt:=xlWhole, _
SearchOrder:=xlByRows, _
SearchDirection:=xlNext, MatchCase:=False)
If Not x Is Nothing Then Cells(i, "c") = "Match"
Next i
End Sub

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Mrbanner" wrote in message
...
I have 2 sheets in 1 excel file 500 rows need to make it so that if
Sheet1:ColB is the same as Sheet2:Colb then the Notes in
Columc:Sheet2 are displayed in sheet1ColumC

note that in most cases the infomation in Colb wont be in the same
order etc. and also a few records missing if this is the case i would
like it to be blank.

Cheers