Is it possible to add an IF function to TEXTJOIN? I would like to make it so if any number in column 5 in the first VLOOKUP is more than 95 then it gives the message "BP". Can this be done?
Here is the formula: =TEXTJOIN("x",,VLOOKUP(A3,FOLDED!$A$2:$I$7,5),VLOOKUP(A3,FOLDED!$A$2:$I$7,6))
Let me know if you need more data...
Thank you.
Here is the formula: =TEXTJOIN("x",,VLOOKUP(A3,FOLDED!$A$2:$I$7,5),VLOOKUP(A3,FOLDED!$A$2:$I$7,6))
Let me know if you need more data...
Thank you.
Last edited: