Forum Discussion
Solved
Use multiple IF functions in one cell without nesting
Hi All, I don't even know if this is possible but here's what I'm trying to do: I have an excel and in cells F, I, M, N and O have a formula that either puts a value or a "not eligible" phra...
=TEXTJOIN(", ",TRUE,IF(F7:O7="Not eligible",F$1:O$1,""))
I'm receiving "An array value could not be found". Why F$1:O$1?
It could be any row. But did not share your workbook, so I made my assumptions.
Or even hardcoded:
{"QA"."".""."Tardies".""."".""."Break & Lunch"."Personal"."Absences"}
Or even hardcoded:
{"QA"."".""."Tardies".""."".""."Break & Lunch"."Personal"."Absences"}