Cell Comments cannot be returned using formulas alone.

VBA is required.

See Debra Dalgleish's site for various macros for dealing with Comments.

http://www.contextures.on.ca/xlcomments03.html


Gord Dibben MS Excel MVP

On Thu, 22 May 2008 11:14:00 -0700, CCorreia
wrote:

I have a spreadsheet that displays a cell's contents in column E based on a
numberical identifier in column B. These cells targeted by the VLOOKUP cell
are located in a seperate part of the same worksheet. I would like to
transfer the comment of the target cell along with the cell data when the
VLOOKUP cell populates. Here is the basic VLOOKUP formula I am using:

=VLOOKUP($B7,$Y$22:$AT$503,2)

Thanks for any help straightening this out, in advance!