Hi! I have a formula that searches an array named "id" for the ## in cell C2. There are multiple matches and these will be combined in one cell using textjoin and returning the value in the array "place". However, I am running into the issue where it is returning values based on partial numbers found:
for example if the number in C2 is 11215 and then a value it is searching for in the array "id" is 1215, it will return values for both 11215 and 1215 numbers. The equation I am using is this
=TEXTJOIN(",",TRUE,IF(ISNUMBER(SEARCH(C2,id)),place,""))
for example if the number in C2 is 11215 and then a value it is searching for in the array "id" is 1215, it will return values for both 11215 and 1215 numbers. The equation I am using is this
=TEXTJOIN(",",TRUE,IF(ISNUMBER(SEARCH(C2,id)),place,""))