You don't need VBA, just the Worksheet Function VLOOKUP.
IF you have a VLOOKUP formula that works except that you get #NA, then edit your formula like
=IF(ISERROR(OriginalFormula),"Not Available in report",OriginalForumla)