Hi JeffreyBrown...Looks like I spoke too soon. The formula did work for the example that I attached but as it went further down the spreadsheet it stopped working. It is pulling the 'Y' or "NO' from the previous set and sometimes its incorrect. Any suggestions?