I need to match criteria in two separte columns and then the third colum with
be fixed text if the criteria matches eg
A1= Yes and B1=Yes then C1(column with the formula in) would show "Generate
Letter"