Excel: Return string if two conditions are met - one being match and one being null in same row

I have a resource library. We are manually managing who has checked out the resources and when they are returned. I have two worksheets in my workbook.

1) With a list of all the resources available

2) An ongoing list of which resources are checked out, by whom, when, and when they are returned

On the first worksheet I want to identify if a resource is currently checked out automatically. This is determined by locating the resource ID in the borrowed resources worksheet, and also identifying that the checked in column is null.

I believe I need to use a combination of if, and, and match, but I can't quite get it. Part of the issue is that the ID number will appear multiple times since the resource will be checked in and out by multiple people over time, so the search can't stop at the first row in which that matches. It has to look through all rows for both the ID number and the null value, and if it finds the combination anywhere within the worksheet, it should return "Yes" in the resource list worksheet.

Please let me know if further clarification is needed. I tried searching through existing posts, and haven't found a combination like this (normally I find what I need right off). Thanks in advance.

** First post...**