Enter formula in B:
=VLOOKUP(A1,{"N","Navy";"A","Army";"F","Air Force";"D","DoD"},2,0)

That should do it!

HTH
--
AP

"kath_moi" a écrit dans le message de
...
I am trying to create a formula where text entered in one cell will
automatically populate another cell with text.

So that if in column A had rows with:

N
A
F
D

then Column B would automatically return:

Navy
Army
Air Force
DoD

seems like it should be easy but for the life of me, I can't get it
working.
Any advice would be appreciated,