small with condition

[omp001]

	A	B	C	D	E
1	value	fruit	animal	bird	water
2	4	yes
3	1
4	3	yes	yes	yes
5	2				yes

Hi all.

Please, I would like a formula to bring SMALL1, SMALL2, ...from A2:A5, if in B:E, same row, there is at least one text "yes".

In the case above the formula should return 2, 3 and 4 as it would be dragged dow in a column.

I know there's an easy way using an auxiliary column, but I would like not to go that way.

thanks in advance

[omp001]

Please, would anyone have any suggestion for this question ?

thanks for your attention