|
|
formula for matching text |
|
Author |
Message |
ctzoey
|
Posted: Mon Apr 17 10:39:47 CDT 2006 |
Top |
worksheet functions >> 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,
Excel355
|
|
|
|
|
Bob
|
Posted: Mon Apr 17 10:39:47 CDT 2006 |
Top |
worksheet functions >> formula for matching text
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)
> 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
|
Posted: Mon Apr 17 10:47:19 CDT 2006 |
Top |
worksheet functions >> formula for matching text
Enter formula in B:
=VLOOKUP(A1,{"N","Navy";"A","Army";"F","Air Force";"D","DoD"},2,0)
That should do it!
HTH
--
AP
> 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,
|
|
|
|
|
|
|