Tried several index, match funtions but no success. Need expert help. Thanks in advance.
Here is the table source with data.
Table 1. Source
<tbody>
</tbody>
I have another table that has list of fruits in one column and all baskets in one row. The result desired is to put x when a fruit is matched from its respective basket. Here is the snapshot of result table.
Table 2. Result with mark "x"
<tbody>
</tbody>
What is the right formula for B2 to D6 to return result as "x" based on data from Table 1?
Here is the table source with data.
Table 1. Source
| 1 | A | B |
| 2 | Basket 1 | Apple |
| 3 | Basket 1 | Pear |
| 4 | Basket 2 | Apple |
| 5 | Basket 2 | Banana |
| 6 | Basket 2 | Grape |
| 7 | Basket 3 | Banana |
| 8 | Basket 3 | Berry |
| 9 | Basket 3 | Pear |
<tbody>
</tbody>
I have another table that has list of fruits in one column and all baskets in one row. The result desired is to put x when a fruit is matched from its respective basket. Here is the snapshot of result table.
Table 2. Result with mark "x"
| | A | B | C | D |
| | | Basket 1 | Basket 2 | Basket 3 |
| 2 | Apple | X | X | |
| 3 | Pear | X | | X |
| 4 | Banana | | X | X |
| 5 | Grape | | x | |
| 6 | Berry | | | x |
<tbody>
</tbody>
What is the right formula for B2 to D6 to return result as "x" based on data from Table 1?
