Insert comments conditionally - ajit

G

Guest

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?
 
G

Guest

How many acronyms do you want to match to comments? If it's a bunch, I'd
probably use VLOOKUP instead.
 
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

2 Conditional formats and insert comment - ajit 7
External Data Toolbar permanently greyed out. 7
insert comment 2
Way to create a note based on the contents entered in a cell? 4
automatic date entry in XL cell.. 3
How do I display spreadsheet comments in a chart? 1
Simultaneouly insert of rows or col. - Ajit 1
VB ; How do I detect a Comment in a cell 5

Top