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