This is in Excel 2007.

In my 1st worksheet I have a list of books with 4 columns:

ID, Title, Authors, Owner

On a 2nd worksheet I have the following columns:

ID, Checked out to, Date

I want in the lookup list for ID in my 2nd worksheet to show the Title,
authors and owner columns but only return the ID of the book.

I can create a lookup list that contains only one column. Any ideas or
suggestions?