Well, I've changed the formula a little, it currently looks like

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

If I add that bit in the middle like you mentioned so it looks like
this....

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

then I get error saying "You've entered too many arguments for this
parameter"


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