Comments are not brought over with this type of function, only the found value.

Bringing Comments over would require a copy/paste which would wipe out your
formulas.

Perhaps some type of event code to attach the Comment to the cell based upon a
value. but I'm not the one to write that.




On Wed, 16 Jan 2008 15:12:00 -0800, Lucy wrote:

Hi there,

There are 2 worksheets on the same workbook.

Sheet#1 consists of raw data
Sheet#2 consists of a Vlookup for looking up data from Sheet#1

I've added comments on several cells in Sheet#1
After I use Vlookup function on Sheet#2, only the cell value shows but NOT
the comments. How can I show the comments as well?

Thanks.