I am attempting to combine the two below steps to reduce two columns to one.
Maybe, I am going about this all wrong but I am looking for a solution to look for a value that is on L List in the column for ref_num but I have to separate it from those numbers. If it's there, display just the match. If it's not there, display this first three numbers from T2.
=TEXTJOIN(",",TRUE,IF(COUNTIF(S2,"*"&L_List&"*"), L_List,""))
=IF(V2="",LEFT(T2,3),V2)
When I tried this formula to combine it (Unsuccessful Attempt):
=TEXTJOIN(",",TRUE,IF(COUNTIF(S2,"*"&L_List&"*"), L_List,LEFT(T2,3)))
I'd get this answer:
Thank you in advanced! I have been stuck on a few issues with this sheet on and off for a couple weeks and this one is at the top of my list.
Maybe, I am going about this all wrong but I am looking for a solution to look for a value that is on L List in the column for ref_num but I have to separate it from those numbers. If it's there, display just the match. If it's not there, display this first three numbers from T2.
=TEXTJOIN(",",TRUE,IF(COUNTIF(S2,"*"&L_List&"*"), L_List,""))
=IF(V2="",LEFT(T2,3),V2)
When I tried this formula to combine it (Unsuccessful Attempt):
=TEXTJOIN(",",TRUE,IF(COUNTIF(S2,"*"&L_List&"*"), L_List,LEFT(T2,3)))
I'd get this answer:
022,022,022,022,022,022,022,022,022,022,022,022,022,022,022,022,022,022,022,022,022,022,022,022,022,022,022,022,022,022,022,022,022,022,022,022,022,022,022,022,022,022,022,022,022,022,022,022,022,022,022,022,022,022,022 |
Thank you in advanced! I have been stuck on a few issues with this sheet on and off for a couple weeks and this one is at the top of my list.