index and match OR?

[The Grim Discovery]

[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A
[/TD]
[TD]B
[/TD]
[TD]C
[/TD]
[TD]D
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]Lionel Messi
[/TD]
[TD][/TD]
[TD]Messi
[/TD]
[TD]FC Barca No 10
[/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Hello

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.

 

[mumps]

In cell A1, try: =IF(OR(C1="Messi",D1="FC Barca No 10"),"Lionel Messi","")