| A | B | C | D | E | F | |
| 1 | YELLOW | RED | GREEN | PINK | SILVER | |
| 2 | ORANGE | X | ||||
| 3 | APPLE | |||||
| 4 | GRAPE | X | X | |||
| 5 | KIWI | X | X | |||
| 6 | BANANA | X | X |
<tbody>
</tbody>
| Kiwi | Formula? |
<tbody>
</tbody>
I need to list the ??? cell with a formula so that it picks up the column header wherever there is an X. For kiwi that is Pink and silver, so how can i list this against kiwi in another table?
Thank you for your help.
