![]() ![]() So instead of showing the error, let us replace them with the word “Not Available.” For this, use the IFERROR function in Excel IFERROR Function In Excel The IFERROR function in Excel checks a formula (or a cell) for errors and returns a specified value in place of the error. So, if the data matches, we get the number otherwise, we get the error value as #N/A. For instance, employee ID, student roll number, customer contact number, seller email address, etc., are unique identifiers. A unique identifier is uniquely associated with all the records of the database. So let us use our favorite function VLOOKUP Function VLOOKUP The VLOOKUP excel function searches for a particular value and returns a corresponding match based on a unique identifier. In the above image, we have two lists of numbers. So we need to use different technologies in these scenarios. The matching data on the row differences method may not always work the value may be in other cells too. #4 Match Data Even If There is a Row Difference Step 5: We must drag the formula to cell C9 to determine the other values.Step 4: Next, we need to apply the formula to get the result.Step 3: We must enter the result criteria if the logical test is “TRUE.” In this scenario, the result criteria are “Matching,” If the row does not match, we need the result as “Not Matching.”.The equals to operator, “=,” is the most commonly used logical test. Step 2: Then, apply the logical test Logical Test A logical test in Excel results in an analytical output, either true or false.Step 1: First, we must open the IF condition in cell C2.How can we leave out the IF condition when we want to match data row by row? In the first example, we have either “TRUE” or “FALSE.” But what if we need a different result instead of the default results of either “TRUE or FALSE.” Assume we need a result as “Matching” if there is no row difference, and the result should be “Not Matching” if there is a row difference. #3 Match Row Difference by Using IF Condition Therefore, we must fill in some colors to highlight the row difference values. Then, click on “OK.”Īs shown in the above window, it has selected the cells wherever there is a row difference. Step 4: In the next window, we must go to the “Go To Special” and choose the “Row differences” option.In the “Go To” window, press the “Special” tab. Step 3: Press the “F5” key to open this window. ![]() read more “F5” to open the “Go to Special” tool.
0 Comments
Leave a Reply. |