Common Lookup in Worksheet and depending columns

Summary

how to show depending columns in worksheet, how to show common lookup

Content

Hi guys,

I have some question about the worksheet display:
1 - is it possible to recover and show a common lookup into the worksheet?

2 - moreover, is it possible to insert a selection list depending the values selected in other column of worksheet (another selection list)

Our use case is the following:
we have:

1.  a CCNL selection list (national collective bargaining employment contract) 
2.  employment rates, selection list that depends by the national contract

 
 
 E.G. referring to the image attached below:
 
 if you select 1000 Contratto Elettrici, you can select just the rates related to the contract selected (LIVELLO A1, LIVELLOA1S and so on..)