Concatenate Name and Address from the Specific Row(s) that Matched Data Validation List Selections

[Turk182]

Hello Everyone,
I would like your help with the following please:

Based on the 2 selections in the validation drop box lists--Zip Code and Business Type-- (see screen shot),
I would like a formula that pulls together (concatenates) the name and address cells from the specific row(s)--on another sheet (see screen shot)-- which matched the previously-selected zip code and business type.

Thanks, Turk182

 

[DanteAmor]

Try:

=FILTER('SBO in the State'!A1:A1000&" "&'SBO in the State'!C1:C1000,('SBO in the State'!F1:F1000=I4)*('SBO in the State'!B1:B1000=L5))