JMB wrote...
Or, if your data in column B (using my previous assumptions) was numeric and
there is only one item that will match your criteria

=SUMPRODUCT(EXACT(A1:A5,C1)*B1:B5)

Unwise if there might be multiple matches.

There's always the array formula

=INDEX(B1:B5,MATCH(TRUE,EXACT(A1:A5,C1),0))