The difference between 0 or 1 in vlookup is: 1. When judging conditions, 0 is regarded as the logical value FALSE, and 1 (any non-0 value) is regarded as the logical value TRUE; 2. The parameters used as function parameters are very different. Large, if the search column data is not sorted, be sure to use 0 as the last parameter. If you use 1, the correct value will not be returned.
The operating environment of this tutorial: Windows 7 system, Microsoft Office Excel 2010 version, Dell G3 computer.
1, When judging conditions, 0 is regarded as the logical value FALSE, and 1 (any non-0 value) is regarded as the logical value TRUE.
For example =if(a1-b1,c1,d1)
If a1 and b1 are equal, then a1-b1=0, which is false, put the value of d1 into the cell where the formula is located , if it is not 0, it is true. Put C1 into the cell
2 where the formula is located. The parameters used as function parameters are very different, such as
=vlookup(a1,b:c,2 ,0) Find a1 in column B and put the corresponding value in column C in the formula cell
If the data in column B is not sorted, be sure to use 0 as the last parameter. If you use 1, it will not The correct value will be returned.
Extended information:
Microsoft Office is an office software suite developed by Microsoft Corporation. It can be used on Microsoft Windows, WindowsPhone, and Mac series Runs on , iOs and Android systems. Like other office applications, it includes integrated server and Internet-based services. Versions of Office from 2007 are called "Office System" rather than "Office Suite", reflecting the fact that they include a server.
Office was originally a promotional name that appeared in the early 1990s and referred to a collection of software that had previously been sold separately. The main promotion focus at that time was: buying a collection will save a lot of money than buying individually. The initial version of Office included Word, Excel and PowerPoint. The "Professional Edition" included Microsoft Access, Microsoft Outlook did not exist at the time.
Related learning recommendations:excel tutorial
The above is the detailed content of What is the difference between 0 or 1 in vlookup. For more information, please follow other related articles on the PHP Chinese website!