index and match OR?

[The Grim Discovery]

	A	B	C	D
1	Lionel Messi		Messi	FC Barca No 10
2
3
4

<tbody>
</tbody>

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","")