Help with cell actions based on other cell content

Please see attachment

Many years ago I created the data in the attached spreadsheet but I have now forgotten how I created it and I would like to add it to a another worksheet.

If you type text in A5 the text will appear in B5 but only if certain conditions are met in the cells above.

Appreciate it if any one could remind me how I did it.

Thanks ... Dennis