Hi John,

I've attached a simplified example of what I am trying to accomplish.
To find the right cell on sheet 2, it has to search by the category i
column A and by the month, but then also it has to find the MIN and MA
for each month.

Sheet1 is a summary of Sheet 2 where it sums the 2 tables together.
want the comment to break out the 2 numbers so you can see what th
total is comprised of. The cell references on the original example i
this thread do exactly match the attachment, but hopefully you ca
better understand what I am trying to do.

Or maybe trying to do a comment is not the way to go? I just need
window to pop up(that is usually hidden), when you click on that cel
to see the breakdown of the numbers.

Thanks for all your help.
Beck

Attachment filename: forum.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=56910
--
Message posted from http://www.ExcelForum.com