The VLOOKUP function goes through a column to look for the value in the first row and then pulls values down.
To find if there is an N #A rather than a specific value, you may need to use this formula in your spreadsheet:
=IF(AND($C$2="N #A",$C$3<>"#REF!"),NA(),CHOOSE($C$2, "Out of range", "Blank", "Weird"))
You are creating an IF statement that checks both $C$2 and $c3 to see if one does not equal "n/a" or "#REF!" and then it determines what answer you want accordingly.