Attach comment to cell using INDEX MATCH in VBA

Hi guys,

I've only ever posted on here once before but the help I got was phenomenal! I am now needing to turn to you geniuses again!

So I've got a few sheets where I will type in an ID (E.G. ID0032.1) and then in the cell next to it, some text that I type, for arguments sake let's say their favourite colour. When that ID number appears (the data is always changing), let's say in cell A1, then B1 is an index match that pulls my comment and displays it next to the ID.

This has worked for me for a while however now I find myself needing to do the same but I would like this "favourite colour" to occupy a comment box, not a cell - the sheet is just too congested.

I hope this makes sense.

Any help would be appreciated, I'm guessing I need VBA?

Thanks again guys!

Thank you!

I have attached a sample. It had lots of confidential information that I've stripped out so it looks bare bones but I've also included a better description of what I need in the workbook itself.

Thanks again everyone! Appreciate you using your free time to help!!

Hi, apologies i might be confusing things with my use of the word "comment" . I mean i would type the text i am now wanting to appear as a comment...

Does that make more sense? 

Originally Posted by AliGW

Right - just to be clear, note or comment? Either way, if it is possible at all (which I somehow doubt, but will be happy to be proved wrong), it will require VBA, so I'm moving the thread now.

Hi, yeah good point... i guess a note would be better than a comment... thank you!

I'm guessing this can't be done guys? :'(