| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lookup text in 1 column and make notations in another
How do I make different notations in 1 column for different texts in another?
In column P I have Regular, Title, Advanced. I want to note R for Regular, A for Advanced, and X for Title in column B. Example: Column B Column P X Title R Regular A Advanced Thanks again for your help. Nordic |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Lookup text in 1 column and make notations in another
=LOOKUP(P1,{"Advanced","Regular","Title"},{"A","R" ,"X"})
Entered in B1 and copied down. Gord Dibben MS Excel MVP On Sat, 3 May 2008 12:38:01 -0700, Nordic wrote: How do I make different notations in 1 column for different texts in another? In column P I have Regular, Title, Advanced. I want to note R for Regular, A for Advanced, and X for Title in column B. Example: Column B Column P X Title R Regular A Advanced Thanks again for your help. Nordic |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lookup text in 1 column and note it in another | Excel Worksheet Functions | |||
| Lookup returning value from antoher column in same row (Text!) | Excel Discussion (Misc queries) | |||
| lookup text in one column, count in another column | Excel Worksheet Functions | |||
| Make new column using partial text in another cell | Excel Worksheet Functions | |||
| How can I make Excel return the text in column A only if there is. | Excel Worksheet Functions | |||
Linear Mode
