In this video I will show you how to fix the #N/A error in excel. It mostly comes with VLOOKUP function. I have used VLOOKUP function to search through the table. When I type some thing that does'nt exist in the table, the formula returns #N/A. That's because there is no such an ID in this table.
To fix it, I used another function. That's IFERROR. It should come at first. After that comes the original formula. After the VLOOKUP formula I put a comma and twice double quotation mark. Bracket close now it's fixed.
I have given this formula in first comment box and the work file can be downloaded from here:
drive.google.c...
16 сен 2024