I have a workbook with Titles, Tests, and Results across columns. I need cell T3 to return the Title if the result is Yes. Each Title should be on a new line. Right now I’m using 6 separate If functions, but in my real scenario, there are many more columns. Is there a way to simplify my formula so that one function can apply to many columns, but keep the results in the same cell? 

​I have a workbook with Titles, Tests, and Results across columns. I need cell T3 to return the Title if the result is Yes. Each Title should be on a new line. Right now I’m using 6 separate If functions, but in my real scenario, there are many more columns. Is there a way to simplify my formula so that one function can apply to many columns, but keep the results in the same cell?     Read More

​