How can I connect numbers to comments

[Jim E]

I want to add comments to student reports by just adding comment numbers in a file. I made a comment table with numbers. Now i want to be able in another table put the number and it pull the comment to the table. but I don't know how.

 

[NARAYANK991]

Hi Jim ,

I think what you mean by comments are not what Excel means by comments.

If you say that you have made a comments table with numbers , I assume you mean that you have a lookup table , where you have numbers down one column , and in another column , corresponding to each number , you have some description.

If all the numbers in the numbers column are unique , then given any number , we can retrieve the corresponding description.

Is this what you want ?

If so , it is very simple to use either the VLOOKUP function or a combination of the INDEX and MATCH functions to get this.

Narayan

 

[ThrottleWorks]

Hi Jin,

Another approch. Save your comments as formula and then type formula name in the cell to populate the comment.
For example, formula name, Com_1, define this formula to cell A1. Type your comment in Cell A1.

The typed comment will reflect where you apply the formula.

Have attached a file for your reference.

 

[Luke M]

If your number-comment table looks like this:
1 - Good Report
2 - Decent Report
3 - Fair
4 - This was terrible!
5 - Completely awful, looks like it was written by SirJB7!

With the numbers being sorted in order, then your formula would be like:
=LOOKUP(A2,TableRange)

 

[SirJB7]

5 - Completely awful, looks like it was written by SirJB7!

@Luke M
Hi!
I don't read you, I don't read you, know it...
Regards!
PS:
PS2: Should I improve my English or change my writing style? One of those is simple while the other is almost perfect... you choose.