Excel Beginners Eliminate VLOOKUP Errors Using IFERROR

The #N/A error in VLOOKUP often appears when the searched data isn't found. The problem is, if left unchecked, Excel reports can look messy and unprofessional. In this video, I show you how to combine VLOOKUP with IFERROR so that: Errors don't appear Results are neater Reports are more readable Formula used: =IFERROR(VLOOKUP(A2,Data!A:C,3,FALSE),"Not found") The example uses a goods transaction dataset, complete with data that isn't found to show the difference. #excel #vlookup #iferror #belajarexcel #excelpemula #exceltips #shortsexcel #tutorialexcel