Typo mistake in Lookup_Value. If you wrongly enter the value in the lookup_value argument of VLOOKUP function, then it generates the #NA error. 
To kill these extra spaces, you need to wrap the Lookup_value argument in the VLOOKUP formula with the TRIM function to ensure correct working of the function, such as In big data set it is very hard to identify these leading or trailing spaces in lookup values that cause the VLOOKUP function to not find the match and return #NA error.
Extra Spaces in Lookup Value. This is one of the most common reasons behind the #NA error in VLOOKUP. There could be some reasons why VLOOKUP returns this error. When VLOOKUP formula cannot find a match, then this error displays, meaning “not available.” But it is always not correct that the lookup value is actually not available. Now you are going to see the reasons for these errors and their solutions. In this article, we are going to discuss VLOOKUP errors, like #NA, #VALUE, #REF, and VLOOKUP returning incorrect results. Here, we are going to discuss some of the common errors and reasons why VLOOKUP does not work. This is because of some limitations with the VLOOKUP function, and sometimes users also do not carefully follow its rules and syntax. But the majority of users complain that VLOOKUP is not working correctly or giving incorrect results. VLOOKUP is very common, popular and widely used function in Excel and Google Sheets. Top Reasons Why Your VLOOKUP is Not Working, and How to Correct Them
0 kommentar(er)
