Fill The Column Match With The Conditions

Is it correct results?
I believe that is typo and "[...] and it will be not input if the data in Table List column RE1 and RE2 are blank.". If are not blank data have to be found.

	B	C	D	E
1	Periode	Code	RE1	RE2
2	Jul/2019	0032678-002	bb	456
3
4	Jul/2019	0062741-002	oo	537
5	Sep/2019	0082124-002	mm	761
6
7		no data	zz	789
8
9	Aug/2019	0058248-002	hh	567

	B	C	D	E
1	Periode	Code	RE1	RE2
2	=IF(C2<>"",IFERROR(INDEX(Input!A:A,MATCH(List!C2,Input!B:B,0)),""),"")	=IF(AND(D2<>"",E2<>""),IFERROR(INDEX(Input!B:B,MATCH(1,(Input!C:C=List!D2)*(Input!D:D=List!E2),0)),"no data"),"")	bb	456

Sheet: List

Formula in col C have to be accept with Ctrl+Shift+Enter as it is array formula.

Originally Posted by omegaboost

Dear KOKOSEK
Thank you for your respond, but actually I expect to get the VBA rather than excel function.

I don't understand why but as you wish. Anyway is the results (top table) as expected?

try:

Please Login or Register  to view this content.