Just so you know, as an alternative to the other replies, you can us
the IF function. for example:

IF(A1="", "", VLOOKUP(*your Vlookup criteria*))

lol, oh wait, that was already suggested, wasn't it

--
Message posted from http://www.ExcelForum.com