Just a quick attempt to support you going in the right direction.
Each “light unit” should be put in one table, with an unique ID that preferable gives an indication of the location, type and other criteria that are important for easy identification.
In your table “lookup” at the column “Ch Number” each instance should be unique too. At least my assumption is that this number is an identification of error.
You could add one column in this table “channel range” where for example “Ch Number” 1183, 1184 are grouped under “wrong color”, where 1183 is for example “red” and 1184 is “green”. (You know better)
An then with a 3rd. table you will use the above information to report, where again the display column is unique, with information on date checked / checked by / location.
And with lookup to the “light unit” table the unit can be selected and with a lookup to the channel list the “error type” can be reported and in the next column you can get it “automatically” displaying the channel range, based on the chosen “channel list ID”.
So overall it’s mostly to get the structure in a meaningful way for your use case, hopeful I have given you some right directions, otherwise feel free to add more info