Hi All,
Need a help please with either using excel formula or Excel VBA to lookup cells with comma separated values.
I have 2 tables below: table 1 and table 2. I will like the Col B (2nd column) of Table 1 to return a true or yes when any of the value is in the Col A (first column) of table 2 are found in that cell.
Your advise here will be greatly appreciated.
Table 1
<tbody>
</tbody>
Table 2
<tbody>
</tbody>
Regards,
Lawrence
Need a help please with either using excel formula or Excel VBA to lookup cells with comma separated values.
I have 2 tables below: table 1 and table 2. I will like the Col B (2nd column) of Table 1 to return a true or yes when any of the value is in the Col A (first column) of table 2 are found in that cell.
Your advise here will be greatly appreciated.
Table 1
Col A: Cells to search | Col B:column to return lookup | |
apple, banana, orange, grape | yes | |
cherry, apple, tomato | yes | |
lettuce, strawberry, durian | no | |
cucumber, grape | yes |
<tbody>
</tbody>
Table 2
Col A: Items |
grape |
apple |
<tbody>
</tbody>
Regards,
Lawrence