excel ammended it slightly to

=IF(ISBLANK(M5),"",IF(ISNA(VLOOKUP(M5,'X:\Reports\ Closed Magic
calls\[Autocorrect.xls]Sheet1'!$A$1:$B$50,2,FALSE)),"",VLOOKUP(M5,'X:\Rep orts\Closed
Magic calls\[Autocorrect.xls]Sheet1'!$A$1:$B$50,2,FALSE)))

but it works a treat, thanks for all your help.

Paul


--
pork1977
------------------------------------------------------------------------
pork1977's Profile: http://www.excelforum.com/member.php...o&userid=36353
View this thread: http://www.excelforum.com/showthread...hreadid=561375