I was wondering if there's a built in worksheet function that would allow the
lookup of row and column data.

For example I have a table like this, that I want to fill in.

James Kirk
Hockey [cell B2]
Soccer

I have a data like this that I want to find the answer for:
[Other.Sheet]
Name Sport Score
James Soccer 10
Kirk Hockey 5
James Hockey 10
Kirk Soccer 10

So in cell B2, I want to write a formula that looks in [Other.Sheet].
If "Name" matches, and "Sport" matches, then return "Score". Can this be
done in Excel? Thanks in advance.