Change the formula to:


=IF(ISNA(VLOOKUP(A20,'2005
information'!$A$4:$L$97,12,FALSE)),"No Respective
Client",=VLOOKUP(A20,'2005
information'!$A$4:$L$97,12,FALSE))


--
Vito
------------------------------------------------------------------------
Vito's Profile: http://www.excelforum.com/member.php...o&userid=29182
View this thread: http://www.excelforum.com/showthread...hreadid=489967