Multiple MATCH

[Forestq]

Hi,

how can I add second MATCH into below function:

OFFSET(Sheet2!$BS$1,MATCH(Sheet1!$H$9,Sheet2!$BR$2:$BR$402,0),0,COUNTIF(Sheet2!$BR$2:$BR$402,Sheet1!$H$9),1))

example: If in one field I select Austria, and in second field I select Wien, I want to have in third filed ALL STREAT for Wien.

Country	City	Street
Austria	Wien	Bohemo
Austria	Wien	Thenok
Austria	Wien	Filator
Austria	Lienz	Abud
Austria	Lienz	Oksor

<tbody>
</tbody>

 

[J.Ty.]

Is your data, from which you get the choices, sorted in the right way?

J.Ty.

 

[Forestq]

I did pivots for all the data, so its sorted

 

[Forestq]

Hi J.Ty.


Thank you for your fluent assistance and finding mistake in my row data.

Regards,
Pawel