Relative Headings

Hello,

I'm trying to make a general certificate that can be used for all the services my company delivers.
The certificate consists of a dropdown list, which contains all services my company can deliver (approx. 20 items), and an input table with data related to the service chosen in the dropdown list.

I would like to have the headings in the input table change depending on the service chosen from the dropdown list.
I've tried using the following IF statement: =IF ($A$1="Pressure Testing";"Pressure";""). I would like to extend this list to include all services.

Regards,

Frank

That did it. Didn't know about that function.

Thanks a lot.

Regards,
Frank