![]() ![]() So we will replace the #N/A error with a customized text “Data Not Found”. ![]() It is better to replace the #N/A error with a customized value that everyone can understand why the error is coming. We can also use IFERROR with the VLOOKUP function on the fragmented data sets from the same worksheet, workbook, or from different workbooks. We will observe that the error has been replaced with the customized value “ Data Not Found“.Įxample #2 – Use of IFERROR with VLOOKUP on a Fragmented dataset So, we will use IFERROR with VLOOKUP Function in Excel in the following way: So it is better to replace the #N/A error with a customized value that everyone can understand why the error is coming. In this situation, the VLOOKUP function will return the #N/A error. Now, we want to search the employees’ basic pay with respect to Employee ID 5902.īut, that employee ID is not present in the list. ![]() In the above figure, we have a list of employee ID, Employee Name and Employee basic pay. Let us take an example of the basic pay of the employees of a company. You can download this IFERROR with VLOOKUP Excel Template here – IFERROR with VLOOKUP Excel Template Example #1 – IFERROR with VLOOKUP
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
December 2022
Categories |