Vlookup excel4/7/2024 ![]() ![]() ![]() (1) In the above formula, A13 is the lookup value, A2:C10 is the table array range, and 3 is the index column number. 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. To return zero instead of #N/A when the VLOOKUP function cannot find the correct relative result, you just need to change the ordinary formula to another one in Excel. Return zero or other specific text instead of #N/A by using advanced VLOOKUPĬonvert all #N/A error value to zero or other text Return zero instead of #N/A when using VLOOKUP This tutorial is talking about returning zero instead of #N/A when using VLOOKUP. ![]() But in sometimes, you want to return zero instead of #N/A when using VLOOKUP function which may make the table look much nicer. In Excel, it appears #N/A when it cannot find the relative correct result by using VLOOKUP formula. ![]()
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |