BDEXTRAE or BDEXTRACT or? How to extract only rows with certain criteria

[jamiguel77]

hi all my data:

Ano	PartNo	Referencia	Amount
2020	22MM23123	50623152	10202
2020	22MM23123	50623152	10283
2020	22MM234232	50623152	23652
2020	22MM435324	50623152	2371
2020	22MM563323	50623152	2382
2020	22MM46363	50623152	23181
2020	22MM67474	50623153	239123
2020	22MM3437	50623154	1239123
2020	22MM774	50623156	129311
2020	22MM56373	50623157	231231
2020	22MM4747373	50623158	12312
2020	22MM3636	50623159	312335		50623152
					#¡VALOR!

in this sample woud be return in cell F15 all rows with criteria of cell F13 in this case '50623152'


not know if the right way is BDEXTRA or BDEXTRACT or any other formula, thanks
thanks, any advice?

 

[jamiguel77]

My Formula is: =BDEXTRAER(A1:D13,C1,F13)