You can see the value we are getting under C2 is “Not Matching” because the text in two columns is not matching with each other. Step 5: Use closing parentheses to complete the formula and press Enter button to see the output. Otherwise, there would be an error with the formula. We will use “Not Matching” as a value for this argument.ĭon’t forget to use the double quotes within which the values should be added. This will be the value being reflected in cell C2 if the logical condition has output as FALSE. Step 4: On similar lines, we must specify a value for the argument. We will use the keyword “Matching” as a value for this argument. This should be the value that will reflect in cell C2 if the logical test has output as TRUE. Step 3: Now, we need to specify value for the argument. You need to use a comma as a separator to separate multiple arguments of the IF statement. In our example, we need to check whether two of the columns have matching values or not therefore, we can use A2=B2 as a logical test under the IF statement. Step 2: The first argument under conditional IF needs a logical test. In cell C2, initiate a formula using a conditional IF statement as shown below: Step 1: Consider the same example as the previous one. Let’s create a custom formula using a conditional IF statement that works in our favor. Having a proper phrase that can let you know whether the data is matching or not matching will be helpful in such cases. Sometimes, just getting values as TRUE/FALSE might not be a good representative when we are comparing two columns for matches. Let’s see a different method to check the same. This is one method using which we could check whether the values under two columns have a match or not. You can validate this by using the Len function as well. But the result is FALSE because we have an extra spacing at the end of cell B5. For Example, see the fifth row where two strings are looking exactly similar, and they should match with each other. There are sometimes extra spaces that allow the text to not match using the equality operator.Note that this criterion for matching does not consider whether the text is in the upper or lower case.Same as with the 4 th output where A4 has value as “Google” and B4 has “Googl”. This is because, for output in C2, A2 has the value “Sweets”, whereas the value in B2 is “swetes”.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |