eechristaylor
New Member
- Joined
- Oct 22, 2013
- Messages
- 40
- Office Version
- 365
- Platform
- Windows
I have a cell with data in it that I know is in the match criteria. The data is in a cell with a large amount of data with it separated by a ";". How can I get it to recognize the data in a large string where it is seperated by a ";"?
For example:
In B1 I have =XLOOKUP(A1,G1:G2,F1:F2,"",0) looking to return a "1"
Any help would be appreciated!
Thanks
For example:
24 | 1 | 10;24;15;16;17;18;28 | ||||
101 | 2 | 11;16;50;55;101;111;124 |
In B1 I have =XLOOKUP(A1,G1:G2,F1:F2,"",0) looking to return a "1"
Any help would be appreciated!
Thanks