Multiple criteria data validation

Hi all,

I am trying to create a multiple criteria data validation drop-down list that then generates an output.

Here is an example of what I mean Multiple data validation.xlsx

I have 3 rows of information and I want to be able to select a firm in B4 and a fund in B5 that then outputs an ID in B6.

I am looking for a way to do this with data validation list drop-downs but not sure how to.

If anyone knows how to do it through data validation or if there is a better or easier way I would love to hear it.

Thanks

Is there a way to get the data validation drop down in B5 to be based on the one in B4.

E.g., Given I have chosen firm Firm D, I can choose only Fund 1