The Grim Discovery
Board Regular
- Joined
- Jan 23, 2015
- Messages
- 241
- Office Version
- 365
- Platform
- Windows
A | B | C | D | |
1 | Lionel Messi | Messi | FC Barca No 10 | |
2 | ||||
3 | ||||
4 |
<tbody>
</tbody>
Can someone help me please? Is it possible to use INDEX/MATCH so that (as in the table above) cell A1 displays 'Lionel Messi' if C1='Messi', OR D1='FC Barca No 10'.
Thanks as ever.