Question: how to get vlookup to return blank instead of na?
Answer: Select the cell you want to use VLOOKUP function, and type this formula =IFERROR(VLOOKUP(A13,$A$2:$C$10,3,0),0), drag the autofill handle to the range you need. ... 
Click Kutools > Super LOOKUP > LOOKUP from Right to Left.