index match with array formula drag down problem

Hi
I used a formula to index match( like a vlookup) and then I drag down because I want the next lines from the other sheet


{ INDEX('PBR2'!$T:$AC,MATCH($X$2&$Z$2,'PBR2'!$A$1:$A$200&'PBR2'!$S$1:$S$200,0)+ROW(),4) } ( array formula)

I use the +ROW() so I can drag down to take the next values, but will bring wrong values because the MATCH will not be verified for each line.


How do I bring the next value ( drag down) and make sure that the MATCH will be checked again.


B cat
A House
A Car
A Radio
B House

( A will not be repeated again, the stay together all times in the sheet)


The A will be checked but only in the first value, after that since I put +row(), I will loose the check


Result today


House
Car
Radio
House


Desired result

House
Car
Radio
Error/Empty

Enter formula in C2 and copy down

Formula:

Please Login or Register  to view this content.

v	A	B	C
1
2	B	cat	House
3	A	House	Car
4	A	Car	Radio
5	A	Radio
6	B	House

Here's another one.

Data Range

	A	B	C	D	E
1
2	B	cat		A	House
3	A	House			Car
4	A	Car			Radio
5	A	Radio
6	B	House
7	------	------	------	------	------

This array formula** entered in E2:

=IFERROR(INDEX(B:B,SMALL(IF(A$2:A$6=D$2,ROW(A$2:A$6)),ROWS(E$2:E2))),"")

** array formulas need to be entered using the key
combination of CTRL,SHIFT,ENTER (not just ENTER).
Hold down both the CTRL key and the SHIFT key
then hit ENTER.

Copy down until you get blanks.