Formulas working for some columns but not others after update

Bryan Letourneau

Good Morning,

It seems after the update I've been having issues with a formula on my project intake sheet/meta data sheet. I'm getting a #No Match error. Certain columns are connecting appropriately but others no longer are and I can't seem to identify why?

See formula below

Below is the intake sheet being referenced with the highlighted needing to captured

Any help would be greatly appreciated!

Bryan Letourneau

Disregard, I figured it out. Thanks!