Formula Help: Check against current borrower

I’m building an inventory management system. One of the pieces is to show what book a Book Club currently has checked out. I can get that info into my table. However, the book title continues to show up in the “Current Book” cell even if someone else has the book now or the book was returned.

Below is the formula I’m trying to use. The formula works to show the book most recently borrowed at the point in the formula which ends at: .First() – trouble begins with everything that follows.


or another attempt:


I think the missing piece is how to check those two statements together. I’ve tried to write an IF statement, but it failed:


Dear @agoodman,

I not sure if you have found a solution, but I recommend to share a dummy copy of your doc, so that somebody will be able to play around and help you out.