Thanks for your help. When using your corrected formula, it works but I'm still getting #N/A on some of my lines that should be equal.
This is what it looks like:

Column A Column B Column C Column D Column E
Row 7: BSER IOWA Match BSER Match BSER Master Match BSER KEY IOWA BSER KEY Not IOWA
#N/A 01F022436-574661 #N/A 01F022436-31IR1 01F022436-574661