Dependent Drop Down Lists

Thanks so much for this - the Excel tables with dynamic range feature is just what I'm looking for. 

Do you know if it's possible to hide results until selections have been made?

E.g.

1) In the first drop down list Select 'Role 1'

2) In the second drop down list select 'Person 1' 

3) In the third drop down list select 'Email' 

4) Only result displayed is the email address of Person 1

Thanks again