Searching for a figure from a column matching a name

[Marvo]

Hi, In the attached workbook, sheet PRIZE WINNERS. I'm trying to get in column X the amount from column M which corresponds with the names in column V from the list in Column B.

So, X3 should display the result of M13 (v3=Brian Adams in 2021)

Hope that makes sense.

I was thinking along the lines of INDEX & MATCH but can't quite work how to formulate it.

Many Thanks.

[AliGW]

Try this:

=SUMPRODUCT(($B$3:$B$143=V3)*($C$2:$N$2=2021)*$C$3:$N$143)

[Marvo]

Thank you Ali, perfect.

[AliGW]

... and thank you for the rep.

[JohnTopley]

Index/March equivalent

=INDEX($C$3:$N$143,MATCH($V3,$B$3:$B$143,0),MATCH(2021,$C$2:$N$2,0))

or another

=SUMIF($B$3:$B$143,V3,INDEX($C$3:$N$143,,MATCH(2021,$C$2:$N$2,0)))

Spoilt for choice!

[Marvo]

Thanks John. I sure am spoilt for choice. I tend to always go for the one I understand, as then I can put it right should it ever go wrong.