example:

A1 = "car" B1 =
A2 = "lorry" B2 =
A3 = "tractor" B3 =
A4 = "bus" B4 =
A5 = "tractor" B5 = "this item has already been entered"


I need a formula to be entered into col"B" to give the message described.
Any suggestion?

Ta