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.

[TABLE="class: outer_border, width: 500"]
<tbody>[TR]
[TD]Country[/TD]
[TD]City[/TD]
[TD]Street[/TD]
[/TR]
[TR]
[TD]Austria[/TD]
[TD]Wien[/TD]
[TD]Bohemo[/TD]
[/TR]
[TR]
[TD]Austria[/TD]
[TD]Wien[/TD]
[TD]Thenok[/TD]
[/TR]
[TR]
[TD]Austria[/TD]
[TD]Wien[/TD]
[TD]Filator[/TD]
[/TR]
[TR]
[TD]Austria[/TD]
[TD]Lienz[/TD]
[TD]Abud[/TD]
[/TR]
[TR]
[TD]Austria[/TD]
[TD]Lienz[/TD]
[TD]Oksor[/TD]
[/TR]
</tbody>[/TABLE]

 

[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