I'm needing to use a formula that will search for the text 'Total' in Column A and if the cell adjacent to it (Column B) has a value '1' to return the word 'Yes'.