Auto Fill based on value of another cell in Excel 2010

[rathidevi]

Dear All,

I need small help from you. In Excel sheet i do have about 1000 records.In that 1000 records, i need to categorize the one particular cell value.

For Ex,

A1 cell value "Password Reset" then b1 cell would be "Related to PWD"
B2 cell value "Access to system:" then b1 cell would be "Related to access".

i do not know the condition for the cell "contains"

If a a1 to a100 contains the word "Password" then automatically it shud fill in b1 to b100 "Password Reset"

tired of filling 1000 records.

if anyone helps on this would be appreciated.

Regards,
Rathi.