Have formula data appear as text, maybe VBA solution?

[Jyggalag]

Hi all!

I currently have this setup, please note that I have hidden all the nonrelevant columns however:

The formula I use is this (thank you @RoryA !)

=IFERROR(INDEX(INDIRECT("'"&H504&"'!$U$3:$U$73"),MATCH(1, (INDIRECT("'"&$H504&"'!$A$3:$A$73")=$C504)*(INDIRECT("'"&$H504&"'!$C$3:$C$73")=$H504),0)),"RANDOM TEXT HERE.")

My issue is that while this is naturally very nice in pulling in data from my other sheet, once you click the actual cell in the current column, it shows the formula rather than the text.

I would like the text to be shown also, and was wondering if I could simply hide column E (or slim it down a lot so it is almost hidden) and then make a new column that automatically replicates all of the text from column E, but where once you click on it, you will be shown the text rather than a formula.

I imagine that this might be possible through VBA coding by altering the entire Column so it just copies the raw data from column E.

Is this possible? I would greatly appreciate some assistance here!

P.S. also open to alternative solutions!

Kind regards,
Jyggalag

 

[Jyggalag]

You are asking exactly the same question, so it's not "too similar"

Apologies for the wording Fluff, English is my 2nd language

My point being was that the question remains the same, but the setup may have been more confusing in this thread, which is why I wanted to update it with a simpler setup with a sum formula and numbers in the other thread.

I appreciate the attention however and if you can help it would be much appreciated!

 

[Jyggalag]

Friendly bump

 

[bebo021999]

Another tip is: create name for the formula:
Ctrl-F3
name: "ABCXYZ"
Refer to: "paste the formula here"
Then in formula bar:
=ABCXYZ
Now the actual formula is hidden, but display the name "ABCXYZ" only.

 

[Jyggalag]

Another tip is: create name for the formula:
Ctrl-F3
name: "ABCXYZ"
Refer to: "paste the formula here"
Then in formula bar:
=ABCXYZ
Now the actual formula is hidden, but display the name "ABCXYZ" only.

but then I have to write all the text right? or did i misunderstand?

bump if anybody has a vba solution