What are reasons for "N/A" when applying Vlookup function and how are these be solved?

When vlookup function return "N/A", when it not found your searched value. 

So, if you want to not show "N/A" error, then you can show your own provided value instead of "N/A" by simply with the help of IFERROR function

Sample contain two column, S.No, Name

Senario: you will provide the S.No to vlookup function to search and return the name

Column A1, B1 are heading

Column A2 to A6 are S.No, and B2 to B6 are names.

=IFERROR(VLOOKUP(3,A1:B5,2,FALSE),"{Your Value}")