Forum Discussion
Solved
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 ...
I suppose you want to return the date IF the cell contains 1; otherwise, you want to return empty text. I hope you now know what formula to use.
I had tried using "IF" but the "1" could be in any cell across the table, and i didnt want to have to create a long formula with 20 "IF" Logical tests!
Is there a shorter way of achieving the same thing?
