LinkBack URL
About LinkBacks
Try this formula.
Formula:
C1 =SUBSTITUTE( A1, "Customer", FILTER($N$1:$N$4, COUNTIF(A1, "*"&$M$1:$M$4&"*")>0, "??") )
Try this formula.
Formula:C1 =SUBSTITUTE( A1, "Customer", FILTER($N$1:$N$4, COUNTIF(A1, "*"&$M$1:$M$4&"*")>0, "??") )
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks