LinkBack URL
About LinkBacks
The syntax of the vlookup isn't wrong here. But I can't get the right result why is that ?
0425153943.png
The syntax of the vlookup isn't wrong here. But I can't get the right result why is that ?
0425153943.png
Try
Formula:
Please Login or Register to view this content.
If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Still can't work here.
Try
=VLOOKUP(10080,C:D,2,0)
It is working here
check the attached file
Why is that? What have you done ?
The "True" as the last argument in VLookup only works if your data is sorted. I can't tell if it is or not. Change it to "False" and see if you agree with Shukia. Sorted small to large or A > Z.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
True or false means Exact Match or Approximate Match. Is it related to the sorting?
I find something if I the range contain the first column (客户名称). The N/A error will show out. Why is that ?
Hi,
The first column in the cell range must contain the lookup_value. For more details about how to use VLOOKUP function, you may read the article below:
https://support.office.com/en-us/art...8-93a18ad188a1
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks