nburaq
Board Regular
- Joined
- Apr 2, 2021
- Messages
- 222
- Office Version
- 365
- 2019
- Platform
- Windows
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.
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
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