I am trying to set up a sheet that shows all racking on site and if it is damaged for whatever reason.

I have a sheet with all the locations in it (sheet 1) and if the location appears on the input sheet (sheet 2) then I want the reason why to appear in (sheet 1). This reason is from another column.

This will then give me a summary for the warehouse rather than sifting through all the repaired and not repaired damages.

Is this possible?