formula for matching text

[kath_moi]

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,

[Bob Phillips]

Create a two column list of letters and values in say M1:N20, then use

=VLOOKUP(A2,$M$1:$N$20,2,False)

where A2 would be the input values.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"kath_moi" <[email protected]> wrote in message
news:[email protected]...
> 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,

[Ardus Petus]

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" <[email protected]> a écrit dans le message de
news:[email protected]...
> 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,