TEXTJOIN with exact match

[nburaq]

Hi,
I would like find the values based on exact match via textjoin function but it gives results even with partial matches. What is the correct formula for that or can you fix mine? Thanks for your help.

Location	Value
ABC	101​
ABC-00A	105​
ABC-00B	106​
ABC-00B-01	110​

I use formula similar to :
=TEXTJOIN(",",TRUE,IF($A$2:$A$5=E2,$B$2:$B$5,""))

If I try only to find value of "ABC" then it brings all the values starting with ABC. Hence instead of showing only value 101 it shows 101,105,106,110

 

[Peter_SSs]

I tried that but then it is giving "CALC! error

You can see that was not the case for me, so there must be something different about your data, layout of formula adaptation. Could you post a small set of sample data with the formula showing the error with XL2BB and then explain what result you would have expected from that sample data.

Also, did the post #8 formula work?

 

[nburaq]

You can see that was not the case for me, so there must be something different about your data, layout of formula adaptation. Could you post a small set of sample data with the formula showing the error with XL2BB and then explain what result you would have expected from that sample data.

Also, did the post #8 formula work?

yes formula #8 works I think the problem is regarded with SAP table that I pulled from the system. I will try it again with an another table. Thanks again for the feedback!

 

[Peter_SSs]

yes formula #8 works

OK, thanks - at least you have something that you can work with.