Forum Discussion
Solved
Returning two results based on one reference
Hi there! https://photos.app.goo.gl/qhGWx9h5KBiSGSHs5 First time posting. In the above linked image, I am trying to return the question and the description for any cell marked as "fail". For ex...
Only if you have Microsoft 365, Office 2021 or Office 2019:
Let's say the sheet with the answers is named Results.
=TEXTJOIN(", ",TRUE,IF(Results!B3:D11="FAIL",Results!B2:D2&": "&Results!F3:F11,""))
For Office 2019, confirm the formula with Ctrl+Shift+Enter.
Only if you have Microsoft 365, Office 2021 or Office 2019:
Let's say the sheet with the answers is named Results.
=TEXTJOIN(", ",TRUE,IF(Results!B3:D11="FAIL",Results!B2:D2&": "&Results!F3:F11,""))
For Office 2019, confirm the formula with Ctrl+Shift+Enter.
- Perfect! Thank you so much!!
