populate a cell if another cell begins with ?

I am trying to figure out how to populate Column N with the Left 4 characters of column F but only if the Left four characters are in the list I specify otherwise Put a "N/A" in the cell and it needs to carry down to the last record. I also need the list to live within the code and after the code is ran I need it to do a Trim on that column.