i have seen many cell by cell comparisons in excel, also column by column comparison.
however i want is comparison of by entire row values.
for example, see attached file. i have two sheets "List 1" and "List 2" in sheet List 1 i want to put a text in column N for those rows that thier match found in List 2 and similalrly, i want to put text in Column N of List2 for those rows that thier match found in List1.
you could these 2 formulas as Array formula Ctrl-Shift Enter
Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.
INDEX and MATCH can be used to great effect to replace HLOOKUP and VLOOKUP as it does not have the limitation of needing the data to be sorted so that the reference value is in the first column or row. It also has the ability to perform a bi-directi…