Hi All, I have a spreadsheet were I want to have N1 have "CB" in it if K1 says "Jerry Warwick" Can anyone help me please. Shazz