Display the "Defined Name" of a cell in a cell when the cell reference is in a cell next to it??

[laurem]

Hello,
I created a scenario summary and in the Result Cells column, all I get is a cell reference.
Is there any way I can do a look up of that cell number located in the other tab so that the "Defined Name" of that cell displays where I wrote the "?"?
I've been searching the web for days, no luck, maybe I am not asking the right question, but I think it should be doable, right?
I also downloaded the Kutools toolbar but I don't think that would help.
PS: I don't know how to do macros, so if your solution involves a macro, please keep that in mind when explaining to me. I am willing to try anything as long as the steps are clear

Thanks so much in advance!

Laure

 

[shg]

You can equally well just type in the range names.

 

[laurem]

Hi there, thanks for your suggestion.

Yes, there is always that typing in the cell option. However I was looking more for an automatic way to have this information filled in so that every time you run a scenario, these headers are in place.

Well. It seems like I eventually found how to fix my problem. All was needed to do was to make sure that every cell that was a variable in my scenario had its matching “defined name”. And now anytime I run a different scenario, those headers are perfectly displayed.

I had never used “defined names” before until now. They're definitely a great tool that deserve more recognition!

Thanks so much again for y'all for your help!