=if(iserror(your vlookup formula),"Incorrect Post Code Entered",your
vlookup formula)

OR you can replace "Incorrect Post Code Entered" with any comments that
you want (as long as they are inside the quotes).

Regards.


--
BenjieLop


------------------------------------------------------------------------
BenjieLop's Profile: http://www.excelforum.com/member.php...o&userid=11019
View this thread: http://www.excelforum.com/showthread...hreadid=381022