I am trying to use a formula similar to match index that will allow me to index based like/similar words in cell. I want the result in Table 2. Table 2 does contain the exact words in Table 1, fruit column I am unable to use index to bring over the totals to Table 2
<colgroup><col><col span="3"><col><col></colgroup><tbody>
</tbody>
Table 1 | Table 2 | ||||
Fruit | Total | Color | TOTAL | ||
Apples | 12 | Apples are red | 12 | ||
Oranges | 15 | Banana are yellow | 7 | ||
Watermelon | 25 | Brown pear | 29 | ||
Banana | 7 | Oranges are round | 15 | ||
Pear | 29 | Watermelon are green | 25 |
<colgroup><col><col span="3"><col><col></colgroup><tbody>
</tbody>