HELLO

I work for a large company and I am trying to build a simple database of our products that can be used by the technical team

we have a range product that requires a text to be attached. there are a total of 30 products that come in 10 different sizes with 20+ different screw threads

each text needs to contain the size and the thread. each product has a different certification

Is there a way I can input a product name size and thread required into 3 separate cells and have a 4th cell produce the required text with the modification's to it ?

I will type each certification variation if need be