InfoPath Dev

That totally worked! Thank you SO much! I do have a quick follow-up question if you don't mind... If it can't find a match, is there a way to make that formula essentially say to just display the abbreviation that was manually input in that case?

This is one of those times where, I am sure that I am missing some obvious glaring answer and it's just because its the end of the week but... I'm at my wits end and hoping someone in this wonderful community can help. I have a form attached to a SharePoint list. When items are entered into that list (a process outside of the InfoPath ...