Why does #N/A appear when using the vlookup function?

Why does #N/A appear when using the vlookup function?

The result of the vlookup function in excel appears #n/a solution

Open a sample worksheet as an example, as shown in the figure:

Recommended: "Excel Tutorial"

Enter the vlookup function in a blank cell to find employees and display the actual wages. As shown in the picture:

#It is found that the result is not correct. Carefully observe the entered formula parameters and compare them one by one. As shown in the figure:

#The second selection area includes the actual salary area, which is also correct. As shown in the picture:

There is no problem with the last return parameter. It turns out that the matching judgment is not set, as shown in the picture:

The above is the detailed content of Why does #N/A appear when using the vlookup function?. For more information, please follow other related articles on the PHP Chinese website!