In Sheet1 C1 enter the formula and copy that down

=IF(ISERROR(MATCH(B1,Sheet2!B:B,0)),"",INDEX(Sheet 2!C:C,MATCH(B1,Sheet2!B:B,0),0))

If this post helps click Yes
---------------
Jacob Skaria


"Mrbanner" wrote:

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