Aggregate formula

[Glacombe]

Hello, I have the following formula and it works super good:

=IFERROR(INDEX('Talent Management'!$B$2:$B$130,AGGREGATE(15,6,(ROW('Talent Management'!$B$2:$B$130)-ROW('Talent Management'!$B$2)+1)/('Talent Management'!$C$2:$C$130="EX-03"),ROWS(E$1:E1))),"")

The part that is underline I would like to stay and add also the data that matches "Well-Placed in Role" that would be found in column "U". Where would I insert that extra argument?

Thanks

 

[Fluff]

How about

=IFERROR(INDEX('Talent Management'!$B$2:$B$130,AGGREGATE(15,6,(ROW('Talent Management'!$B$2:$B$130)-ROW('Talent Management'!$B$2)+1)/('Talent Management'!$C$2:$C$130="EX-03")/('Talent Management'!$U$2:$U$130="Well-Placed in Role"),ROWS(E$1:E1))),"")

 

[Glacombe]

How about

=IFERROR(INDEX('Talent Management'!$B$2:$B$130,AGGREGATE(15,6,(ROW('Talent Management'!$B$2:$B$130)-ROW('Talent Management'!$B$2)+1)/('Talent Management'!$C$2:$C$130="EX-03")/('Talent Management'!$U$2:$U$130="Well-Placed in Role"),ROWS(E$1:E1))),"")

Thanks Fluff, the results shows a blank cell, the formula starts in row E4 would I need to change to that from E$1:E1?

 

[Glacombe]

Thanks Fluff, the results shows a blank cell, the formula starts in row E4 would I need to change to that from E$1:E1?

Hey Fluff I found the mistake, there was an extra space between "placed and in" from my data sheet, it does work again thanks

 

[Fluff]

You're welcome & thanks for the feedback.