If you are not a fan of excel formulas Excel Formulas The term "basic excel formula" refers to the general functions used in Microsoft Excel to do simple calculations such as addition, average, and comparison. 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 work all the time the value may be in other cells too. #4 Match Data Even If There is a Row Difference
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |