Dynamic Comment Box

[Adroitking]

I have a series of vlookup functions running down a column. I would like to have a description of the returned function within a comment box. The description is next to the vlookup reference range on another sheet, and is typically several sentences long. How can I create a dynamic comment box, which is conditioned upon the value within the cell?

Has anyone attempted this?

 

[erik.van.geit]

Hi,

An example would help.

kind regards,
Erik

 

[Adroitking]

For example:

The cell Sheet1!A1 is an input cell, which requires a code number (ie 123ABC). Once the code is typed in, Sheet1!B1 returns the name of the code based on a lookup value "=VLOOKUP(A1,Sheet2!A:B,2, FALSE)".

In the third column on Sheet2 I have a description of the code, which I would like to place a comment. In other words, I would like to have a formula in a comment. The description in the comment will change if I change the code number.

Does this help?

 

[erik.van.geit]

on sheet2 column C there is a description
Do you want to get that description in a comment linked to B1?

Say sheet2 row 3 has
123ABC Name3 Description3

sheet1 B1 would have
value: Name3
comment: "Description3"

is that OK?
By the way: it will involve code.

best regards,
Erik