Easiest way to make two columns into a match formula?
All, Simple task, but on a great scale.I have a table with two columns that have two different naming conventions for the same thing. Few hundreds of rows. Let's say something like that:NATO reporting name Common nameFaceplateMikoyan-Gurevich Ye-2A**bleep**otMikoyan-Gurevich MiG-15FangLavochkin La-11FantailLavochkin La-15FantanNanchang Q-5/A-5FargoMikoyan-Gurevich MiG-9FarmerShenyang J-6 and Miko...