Forum Discussion
I want catalog to tell me if a book is checked out and by who
Hello I have a catalog of books (Sheet 1). I have a check in/out system (Sheet 2) based on ISBN and essentially an on/off function that counts if a book is checked out or not. If there is text for ch...
A sample workbook would help. You could setup a table and utilize the new check box feature to isolate checked out books. The formula would be simple:
=FILTER(BooksTbl[[Title]:[Author]],BooksTbl[Checked out],"None")The data arranged: