HelpwithExcelPlease
New Member
- Joined
- Sep 8, 2022
- Messages
- 1
- Office Version
- 365
- Platform
- Windows
Hi,
I've spent several hours trying to find a solution, done some trial and error yet I'm truly stuck. Could someone please help me.
I have two tables. Table A has unstructured text. Table B is a list of comma separated keywords. I want to match all comma separated keywords from Table B to any cell in Table A. If all keywords are not present from the any given cell in a list then it should not count as a match. The formula doesn't have to be case sensitive as I can uppercase the keyword and text.
If a cell in Table A does match all keywords in cell from the list in Table B then I want it to return True/False. Also I want to return a value in another showing the matching cells from the Table B.
I have attached example of the results I hope to achieve. Thank you very much for reading.
I've spent several hours trying to find a solution, done some trial and error yet I'm truly stuck. Could someone please help me.
I have two tables. Table A has unstructured text. Table B is a list of comma separated keywords. I want to match all comma separated keywords from Table B to any cell in Table A. If all keywords are not present from the any given cell in a list then it should not count as a match. The formula doesn't have to be case sensitive as I can uppercase the keyword and text.
If a cell in Table A does match all keywords in cell from the list in Table B then I want it to return True/False. Also I want to return a value in another showing the matching cells from the Table B.
I have attached example of the results I hope to achieve. Thank you very much for reading.
