Hi. looking to create a vlookup that will lookup the value obviously but also if blank display "NA", and also if the lookup value isn't in the look up list, display "error". currently i have the following.
=IF(ISERROR(VLOOKUP(B2,LEGEND!A:B,2,FALSE)),"NA",VLOOKUP(B2,LEGEND!A:B,2,FALSE))
Bookmarks