Hi MelbTim,

When you use VLOOKUP and the search item is not present in the table,
it returns #N/A. To avoid this, you could use some thing like:
=IF(ISERR(VLOOKUP($A12,'[referraldata.xls]autodata(Bei)'!$A$6:$I$10000,2,0)),VLOOKUP($A12,'[referraldata.xls]autodata(Bei)'!$A$6:$I$10000,2,0),"")

This will put a blank space in the cell where you now get the #N/A

Mangesh


--
mangesh_yadav
------------------------------------------------------------------------
mangesh_yadav's Profile: http://www.excelforum.com/member.php...o&userid=10470
View this thread: http://www.excelforum.com/showthread...hreadid=375130