I want to search a column for a specific value. On finding it I want to
populate a cell in another column with another defined value. Example:
search finds value in A1 (say 99000012) and populates B1 with new value (say
P35) where 99000012 will always equal P35. My spreadheet is 6500 lines I
have 5 values to identfy and set corresponding new values in the new column.