Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.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, |
#2
Posted to microsoft.public.excel.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) "kath_moi" wrote in message ... 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, |
#3
Posted to microsoft.public.excel.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 "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, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convert text to formula - Help pleaaase | Excel Discussion (Misc queries) | |||
text in formula explaining formula not to print | Excel Worksheet Functions | |||
Formulas dealing with text data | Excel Worksheet Functions | |||
Using the text from a cell as a range name in a formula | Excel Discussion (Misc queries) | |||
Concatenation formula loses text wrap formatting | Excel Discussion (Misc queries) |