VBA to make a detail in a cell with a formula already in it

I have an excel that needs to have a detailed value that shows up on the cell that has values in it made by lookup formula.
The problem is, i don't know how to say it, just when I clicked a cell with a formula, it shows how it was made (The values that makes its value).
Example: I cliked B3 on 1st sheet it should show
AM120=(value)
AM130=(value)
And so on....
Any help would be appreciated

I attached a file just to make clear.
Trying to figure the formula out with details.xlsx

Hello irahatam,

So are you saying that your look-up formula yields a numeric result, and you are wishing to add additional text, before or after that result?

Originally Posted by KSSLR

Hello irahatam,

So are you saying that your look-up formula yields a numeric result, and you are wishing to add additional text, before or after that result?

Well yes, after the result. I meant when i click B3 cell, it shows the details of each AM products that makes the total of it, like showing a note on the right side of the cell.

Well, Matahari, I think what you are looking for is a message box (the little pop-up box). Hopefully someone on this forum, who speaks Excel 2003, can give you the exact formula you need.

Originally Posted by KSSLR

Well, Matahari, I think what you are looking for is a message box (the little pop-up box). Hopefully someone on this forum, who speaks Excel 2003, can give you the exact formula you need.

Okay, still waiting...

I found it! And it's 2003! :-D

http://www.ozgrid.com/forum/showthread.php?t=50875

Okay thanks, 1 solved. But how to put formula for the details?