Register now or log in to join your professional community.
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}")
