richard_d1
New Member
- Joined
- Feb 7, 2022
- Messages
- 9
- Office Version
- 365
- Platform
- Windows
I am trying to write a formula which checks if a cell value is in a list. So I have:
And this works fine, checking if the value in D2 appears in the list in column A.
However, I want to include wildcards in the list in column A. So for example:
And then typing a code into D2, it checks whether it begins with one of those strings or not.
Is that possible?
Thanks.
Excel Formula:
=ISNUMBER(MATCH(D2,A:A,0))
And this works fine, checking if the value in D2 appears in the list in column A.
However, I want to include wildcards in the list in column A. So for example:
AAA* |
AAB* |
AAC* |
AAD* |
AAE* |
And then typing a code into D2, it checks whether it begins with one of those strings or not.
Is that possible?
Thanks.