Drag the formula to the remaining cells to get the result.If Source 1 is equal to Source 2, we will get the result as TRUE or else FALSE. Since we are matching Source 1 = Source 2, let’s select the formula as A2 = B2.SUM, COUNT, COUNTA, COUNTBLANK, AVERAGE, MIN Excel, MAX Excel, LEN Excel, TRIM Excel, IF Excel are the top ten excel formulas and functions. read more The term 'basic excel formula' refers to the general functions used in Microsoft Excel to do simple calculations such as addition, average, and comparison. This can be done by simple basic excel formulas Basic 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. We have city names from two different sources we need to match whether Source 1 data is equal to Source 2 or not.