This is not possible through the User Interface. It would be possible using
code, but would be 'cludgy' in comparison to using another cell and a
VLOOKUP to display the result

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
nick_hodgeTAKETHISOUT@zen.co.uk.ANDTHIS


"rkloess" <rkloess.1t3kma_1122919501.4847@excelforum-nospam.com> wrote in
message news:rkloess.1t3kma_1122919501.4847@excelforum-nospam.com...
>
> Hi!
>
> I would like to customize a comment (Excel) by using a formula. Is that
> possible in any way?
>
> The solution is supposed to look like this:
>
> Entered data in Cell: eg. Steel 1 Comment: weight per foot 10lbs
> Entered data in Cell: eg. Steel 3 Comment: weight per foot 5 lbs
> Entered data in Cell: eg. Pipe Comment: weight per foot 1 lbs
> Entered data in Cell: empty Comment: Enter type of material
>
> THX
>
> Rainer
>
>
> --
> rkloess
> ------------------------------------------------------------------------
> rkloess's Profile:
> http://www.excelforum.com/member.php...o&userid=25783
> View this thread: http://www.excelforum.com/showthread...hreadid=391867
>