Hi all - first post, would appreciate some help. I have an extract from SharePoint on Excel and I want to do a lookup against my Excel mapping table.
The table I have in the spreadsheet is the "List from SharePoint" where I have a string with lots of # and ;s, I want to use that string and lookup against a table and count how many vegetables/fruit there are.
I would like the outcome of the lookup to be the numbers in orange below, is this feasible? I prefer to use the mapping table as my list of vegetables & fruit are quite long
Thanks.
<tbody>
</tbody><colgroup><col><col span="2"></colgroup>
The table I have in the spreadsheet is the "List from SharePoint" where I have a string with lots of # and ;s, I want to use that string and lookup against a table and count how many vegetables/fruit there are.
I would like the outcome of the lookup to be the numbers in orange below, is this feasible? I prefer to use the mapping table as my list of vegetables & fruit are quite long
Thanks.| List from SharePoint | Lookup output: Fruit | Lookup output: Vegetable |
| ;#Apple;#Pear;#Carrot;# | 2 | 1 |
| ;#Apple;#Pear;#Tomatoes;#Carrot;# | 2 | 2 |
| Mapping table | Type | |
| Apple | Fruit | |
| Pear | Fruit | |
| Carrot | Vegetable | |
| Tomatoes | Vegetable |
<tbody>
</tbody><colgroup><col><col span="2"></colgroup>
