Buzz
Many users encounter #N/A error when using VLOOKUP function in Excel. This is the error result when the execution command cannot find the value. VLOOKUP error can occur with any Excel version if users execute the command incorrectly.
How to fix VLOOKUP error, #N/A error
Key Points:
Lookup_value: The value used for searching
Table_array: The lookup table, in absolute address form (with $ sign by pressing F4)
Col_index_num: The order of the column from which to retrieve data in the lookup table.
Range_lookup: The search range, TRUE is equivalent to 1 (for approximate match), FALSE is equivalent to 0 (for exact match).
Looking at the spreadsheet, C10 is the lookup value, $F$10:$G$13 is the absolute lookup range, and 2 is the display order of the lookup table. 0 represents an exact match (FALSE)
-> Thus, we see that the formula is completely fine. The #NA case occurs when there is no value with the code A005 in the lookup table. This results in a not found error, leading to a Vlookup error.
Step 2: Add the value A005 with any item name as you wish, adjust the formula with the extended absolute lookup column, encircle the area where A005 code is equivalent to G14 position in Excel.
Step 3: Press Enter, then drag down to copy the formula batch, resulting in the following outcome.
Furthermore, please remember. A common issue with #NA causing Vlookup errors is not anchoring the data range for value lookup. So, when selecting the lookup value range, remember to press F4 to anchor the range.
Here, Mytour has partially addressed your concerns regarding the Vlookup #NA error. If you still have queries, feel free to reach out to us for assistance. Additionally, if you wish to enhance your Excel proficiency, you can explore further technical functions within Excel. Supplementing with additional technical functions in Excel will enhance your proficiency in task handling and learning.
