Lookup date and ticker and return price

This should be fairly easy, but for some reason I am really struggling...

What I need is a formula that finds the ticker (actually it is a CRSP permanent number) and the date in Sheet 1 and returns the price in Sheet 2 (cell B2 etc.), and if no price is available, return 0.

I have attached a shrinked example (the actual dataset contains more than 150.000 observations). example.xlsx

Hope you are able to help me. Many thanks in advance!

Best,
Borge

=SUMIFS(Sheet1!$C$2:$C$112,Sheet1!$A$2:$A$112,B$1,Sheet1!$B$2:$B$112,$A2)

copy across and down

Thank you so much for the swift reply! This works perfectly - totally forgot about the SUMIFS-function

You're Welcome!