| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lookup text in 1 column and note it in another
How do I find certain text in one column and note it in another.
Example: Column P has Title and Regular in it. I want to note each time Title is found and note it with an X in column B. Column B Column P X Title Regular Regular X Title Thanks for your help. Nordic |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Lookup text in 1 column and note it in another
=IF(P2="Title","X","")
copy down -- Regards, Peo Sjoblom "Nordic" wrote in message ... How do I find certain text in one column and note it in another. Example: Column P has Title and Regular in it. I want to note each time Title is found and note it with an X in column B. Column B Column P X Title Regular Regular X Title Thanks for your help. Nordic |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lookup returning value from antoher column in same row (Text!) | Excel Discussion (Misc queries) | |||
| Validation note to comment note | Excel Discussion (Misc queries) | |||
| lookup text in one column, count in another column | Excel Worksheet Functions | |||
| How paste text from note pad to excel w/o using (Text to column) f | Excel Worksheet Functions | |||
| How do I build a free text note from a template? | Excel Worksheet Functions | |||
Linear Mode
