_ENLR and _NO are listed in the name manager with the information below it. The basic thing I'm trying to figure out is how to do the formula. I had it in an excel before I just don't know how I lost it. I think it used MATCH and ISNA.
If a Soldier is RANK and STATUS matchs the one of the...