Keep source formatting of text in lookup cell

[leobi]

Hello!

I've created a file in excel that allows me to dynamically update the features of a set of products, including their name, claim, size, and ingredients. See simplified example attached.

In this example - there is a source sheet "Ingredients" where there is the list of ingredients per product - and where the allergens are in BOLD

There is a 2nd sheet - "Product overview" where there is the full overview of the product, including the ingredients, which is getting pulled via a simple "=CELLNAME" formula.
Then there is 3rd sheet - "HLOOKUP" - this is there because I also pull the ingredients via an HLOOKUP of the results in the "Product Overview" in to a 3rd sheet.

My question is: How can I make it so that the bolding of ingredients form the source sheet persists through to the 2nd sheet and then from the 2nd sheet to the 3rd sheet?


Further context: I'm using this file as a way to share this information with a packaging designer who needs to know exactly which ingredients will need to be in bold on the packaging.

Thank you so much!
Leo