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 checked out and in, it gives me 2, if there is text for just checked out, it gives me 1. What I want to do is have the catalog tell me if a book is checked out and by who. I was trying to do based on the range of ISBN column where the ISBN matches the ISBN of a certain book AND where my checked in/out counter is 1. So let's say the 13th row of Sheet 2 has ISBN 1234 checked out by John Doe and it is not checked in, I want row 1234 on Sheet 1 to tell me the name on row 13 of Sheet 2. (ISBN column is B on sheet 1 and 2 Checked in/out column is E in sheet 2) I tried =if(AND(Sheet2!$B$2:$B$10000=B1234, Sheet2!$E$2:$E$10000="1") for the logical test but I do not know how to make it populate the name column at that particular row where those two things are true (in this case row 13). 

Ideally if there was a way for me to see the last person to check it in that would be cool. Basically same if statement but when the E column=2 (if there is no E column=1) but then it would populate all the times someone checked that book in, but I only want the most recent, so the largest row number. Maybe I'm trying things that just are not possible, but I would appreciate any help or redirection.