Forum Discussion

Iron Contributor

Jan 28, 2020

Comments binding

Is there any way to make a comment "stick" to a specific value? For example, C2=00912 Comment on C2 is, "this employee is awesome" If I type 00912 in any cell on any sheet, I would like to s...

excel

Charla74

Iron Contributor

Jan 30, 2020

Can you share the file?

Ocasio27
Iron Contributor
Jan 30, 2020
Charla74
Its not a specific file, I just want that when a comment is placed on a cell value, then that comment repeats on any other cell that has the same value in any other page.
- PReagan
  Bronze Contributor
  Jan 30, 2020
  Hello Ocasio27,
  
  This would not be possible without the use of VBA. And even so, I do not have an answer for this. Is it necessary to apply a comment to a certain value? Why not add a column to refer to via VLOOKUP() or INDEX()+MATCH()?