HOW TO: If cell contains specific text that is part of a different list then return specific text

I'm using Excel 2016 and I have successfully locked all cells except for a few that need data entry.  My sheet contains several text boxes.  When I select all, and lock all cells, then manually unloc...