If you have Excel 2007, you can use the more elegant

=IFERROR(VLOOKUP(A12,'Books Borrowed'!$A$5:$G$35,3,0),"")


--
__________________________________
HTH

Bob

"Fred Smith" wrote in message
...
Then you want this:

=IF(ISNA(VLOOKUP(A12,'Books
Borrowed'!$A$5:$G$35,3,0)),"",VLOOKUP(A12,'Books
Borrowed'!$A$5:$G$35,3,0))

This is a very common structure when using Vlookup.

Regards,
Fred.

"DDD" wrote in message
...
Though, it did not make the message "#N/A" dissapear, you have been able
to
shorten my formula,

thanks, last time i tried the same formula, it didnt work for some
reason, &
after copying & pasting yours, it worked

"Max" wrote:

Perhaps this in S12 might suffice:
=IF(A12="","",VLOOKUP(A12,'Books Borrowed'!$A$5:$G$35,3,0))
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:20,500 Files:365 Subscribers:65
xdemechanik
---