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 example, if cell C6 or C10 is "Fail" I would like to return, in a different tab, C2 and E6.
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 example, if cell C6 or C10 is "Fail" I would like to return, in a different tab, C2 and E6.
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.
2 Replies
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!!
