If you are retrieving text with the VLOOKUPS() you could simply format the cells containing those formulas with this custom format: ;;"DATA"

As for the ISNA() you could use IFERROR() if you are using Excel 2007 as your profile shows.

=IFERROR(your current formula,alternative)

http://www.excelfunctions.net/Excel-Iferror.html