 Hello viewers, welcome to my channel. In this video we are going to see how to remove this error. This error is occurred due to no value to pull up by the VLOOKUP formula. This VLOOKUP formula is working fine when it get values to pull up, but until that this formula will show as error. When VLOOKUP formula get its search key value it's getting the output. Until the search key was found this formula show as error. This video is about how to hide this error in the sheet without affecting the VLOOKUP function. To hide the error we are going to use IFERROR function. Insert IFERROR function before that VLOOKUP function and use the old VLOOKUP formula as value in IFERROR function. And in value IFERROR type blank space in the double code so we can get blank instead of error. And that's it, now just copy and paste the formula in the column. In a similar way just do it in the next column. Now you can see that the error is just disappeared in the formula but the formula works fine when the search key value found for that VLOOKUP formula. Thanks for watching this video, kindly check out my other videos. If this video is useful to you, kindly like, share and subscribe to my channel. Thank you.