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

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

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

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