Version of Lookup formula?

Have a table dates across the top and items down the side.   The body of the table gets populated with "1s" which auto formats to a cell colour.   Id like to create a column that looks up when a ...