That may also be highly impracticable, if you have large or complex spreadsheets where cell values are results of other calculations-or maybe there are other logical reasons why you simply cannot move the columns around. If that’s not possible, then try moving your columns. Solution: You can try to fix this by adjusting your VLOOKUP to reference the correct column. In this case, Excel is looking for it in column A, not column B. The #N/A error results because the lookup value “Kale” appears in the second column (Produce) of the table_array argument A2:C10. In the following table, we want to retrieve the number of units sold for Kale. If your lookup value is not in the first column of the array, you will see the #N/A error.
One constraint of VLOOKUP is that it can only look for values on the left-most column in the table array. Problem: The lookup value is not in the first column in the table_array argument You can share the PDF with others or print for your own reference. Tip: Also, refer to the Quick Reference Card: VLOOKUP troubleshooting tips which presents the common reasons for #NA issues in a convenient PDF file.
0 kommentar(er)
