Attaching Comment to cell contents rather than cell

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

El Damo - 11 Dec 2006 11:29 GMT

I have a spreadsheet that is regularly upadated overwriting columns,
however I need to enter comments on the sheet referenced on the
content. The next time I update the sheet the referenced cell will
move down a row, but I need the comment to stay with the content rather
than the cell.

Any suggestions?

Many thanks

Reply to this Message

Dave Peterson - 11 Dec 2006 12:43 GMT

If the values that you're commenting are unique, you may want to toss the
comments and create a table in another worksheet.

Value Comment

Then use an =vlookup() formula to return the "comment" to the adjacent cell.

> I have a spreadsheet that is regularly upadated overwriting columns,
> however I need to enter comments on the sheet referenced on the
[quoted text clipped - 5 lines]
>
> Many thanks

Signature

Dave Peterson

Reply to this Message

El Damo - 11 Dec 2006 14:20 GMT

Thanks for this Dave, but me being really quite thick could you
elaborate.

Ta
Damo

> If the values that you're commenting are unique, you may want to toss the
> comments and create a table in another worksheet.
[quoted text clipped - 12 lines]
> >
> > Many thanks

Reply to this Message

Dave Peterson - 11 Dec 2006 14:42 GMT

Say your comments go into cells with unique part numbers.

Create a table on another worksheet:

Col A Col B
----- ------------------------
Part1 This is comment1.
Part2 This is a second comment
...
PartN This is the last column.

Then use that part number to bring back the comment into an adjacent cell.

=if(iserror(vlookup(a2,sheet2!a:b,2,false)),"",vlookup(a2,sheet2!a:b,2,false))

Debra Dalgleish has some notes:
http://www.contextures.com/xlFunctions02.html (for =vlookup())

> Thanks for this Dave, but me being really quite thick could you
> elaborate.
[quoted text clipped - 22 lines]
> >
> > Dave Peterson"

Signature

Dave Peterson

Reply to this Message

Dave Peterson - 11 Dec 2006 15:07 GMT

PartN This is the last COMMENT.

> Say your comments go into cells with unique part numbers.
>
[quoted text clipped - 44 lines]
>
> Dave Peterson

Signature

Dave Peterson

Reply to this Message