You need to explain what you want to do, and attach an example file not images.
If the word fail is entered into column k for any of the individual trailers Master, camera, regular (green) regular (grey), flash. I want the dates of the fail from column A of that row to be posted in columns P,Q,R,S,T. Note color and name differentiates trailers individually. The second pic is a mock up of what I want. If anyone could help me it would be much appreciated. I am not experienced user, so please dumb it down to me. Thank you.
As I said attach the example workbook
I can not attach the whole work book due to rules of employment, sorry.