| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Insert comments conditionally - ajit
I want to insert the comment conditionally e.g. if the cell contains
"IT" insert the comment "India Today", "TOI" insert comment as "Times of India" etc. How Can I perform this operation? -- Knowldege is Power |
|
#2
|
|||
|
|||
|
How many acronyms do you want to match to comments? If it's a bunch, I'd
probably use VLOOKUP instead. "Ajit Munj" wrote: I want to insert the comment conditionally e.g. if the cell contains "IT" insert the comment "India Today", "TOI" insert comment as "Times of India" etc. How Can I perform this operation? -- Knowldege is Power |
|
#3
|
|||
|
|||
|
Hello Barb,
Yes, its a bunch of about 40-50 names. Some of them are like: TOI=TIMES OF INDIA IT= INDIA TODAY IE= INDIAN EXPRESS ECO=ECONOMIC TIMES etc. Pl. elaborate -- Knowldege is Power "Barb R." wrote: How many acronyms do you want to match to comments? If it's a bunch, I'd probably use VLOOKUP instead. "Ajit Munj" wrote: I want to insert the comment conditionally e.g. if the cell contains "IT" insert the comment "India Today", "TOI" insert comment as "Times of India" etc. How Can I perform this operation? -- Knowldege is Power |
|
#4
|
|||
|
|||
|
This should help
http://www.mvps.org/dmcritchie/excel/vlookup.htm "Ajit Munj" wrote: Hello Barb, Yes, its a bunch of about 40-50 names. Some of them are like: TOI=TIMES OF INDIA IT= INDIA TODAY IE= INDIAN EXPRESS ECO=ECONOMIC TIMES etc. Pl. elaborate -- Knowldege is Power "Barb R." wrote: How many acronyms do you want to match to comments? If it's a bunch, I'd probably use VLOOKUP instead. "Ajit Munj" wrote: I want to insert the comment conditionally e.g. if the cell contains "IT" insert the comment "India Today", "TOI" insert comment as "Times of India" etc. How Can I perform this operation? -- Knowldege is Power |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I conditionally insert an image (.bmp file)? | Excel Worksheet Functions | |||
| 2 Conditional formats and insert comment - ajit | Excel Discussion (Misc queries) | |||
| Simultaneouly insert of rows or col. - Ajit | Excel Discussion (Misc queries) | |||
| insert picture | Excel Discussion (Misc queries) | |||
| Challenging Charting | Charts and Charting in Excel | |||
Hybrid Mode
