Shulou(Shulou.com)06/02 Report--

Xiaobian to share with you the difference between 0 or 1 in vlookup, I hope you have something to gain after reading this article, let's discuss it together!

The difference between 0 and 1 in vlookup is: 1. When judging the condition, 0 is regarded as the logical value FALSE, and 1 (any non-zero value) is regarded as the logical value TRUE;2. The parameters used as functions are very different. If the search column data is not sorted, be sure to use 0 as the last parameter. If 1 is used, it will not return the correct value.

This tutorial will operate on Windows 7, Microsoft Office Excel2010, Dell G3 computers.

1, conditional judgment, 0 is treated as a logical value FALSE, 1 (any non-zero value) is treated as a logical value TRUE.

For example =if(a1-b1,c1,d1)

If a1 and b1 are equal, a1-b1=0, false, put the value of d1 in the cell of the formula, if not 0, true, put C1 in the cell of the formula

2. Parameters used as functions vary greatly, for example

=vlookup(a1,b:c,2,0) Find a1 in column B and put the corresponding column C value in the formula cell

If column B is not sorted, always use 0 as the last parameter, otherwise it will not return the correct value.

Additional information:

Microsoft Office is a suite of office software developed by Microsoft Corporation that runs on Microsoft Windows, Windows Phone, Mac Series, iOs and Android. Like other office applications, it includes federated servers and Internet-based services. Office versions from 2007 are called "Office System" rather than "Office Suite", reflecting the fact that they include servers.

Office was originally a promotional name that appeared in the early 1990s, referring to a collection of software previously sold separately. At the time, the main focus of the promotion was that buying a collection would save a lot of money than buying it separately. The original version of Office included Word, Excel, and PowerPoint. Professional Edition included Microsoft Access , Microsoft Outlook did not exist at the time.

After reading this article, I believe you have a certain understanding of "what is the difference between 0 or 1 in vlookup". If you want to know more relevant knowledge, please pay attention to the industry information channel. Thank you for reading!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.