formula for matching text
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,
|