Formula Index-Match with 2 criteria NON array and NON VBA

[VeKa27]

Hi Guys,
Need your help on this one.. I have a tabel that looks like this one: (data can be filled in with blanco lines between)

Status	Mark	Type	Fuel	Plate	KM	Omnium	Omnium Until	Winter Tyres	Color	Remarks
Active	BMW	320	G	ABC-123-5	60000	Yes	30/06/2020	No	White
Non Active	Mercedes	A-Class	UNL	ABC-321-9	32000	No	31/12/2019	No	Grey
Active	Audi	A6	G	ABC-222-2	51000	Yes	25/05/2020	Yes	Black
Non Active	Audi	A3	UNL	ABC-333-5	20	Yes	25/08/2020	Yes	Red
Active	VW	Passat	G	ABC-555-3	25000	No	None	No	White

Now i have another litle tabel where the user needs to lookup some value on 2 criteria. First the markname and second the status of the vehicle.

Audi	Non Active
Type + Fuel:	G
Plate:
KM:
Omnium + Date Until:
Winter Tyres:
Color:

So, the field where now "Audi" stands is selectable on all marks. For example if the user chooses "Audi".
The field besides is also selectable between "Active and Non Active".
After selection, the information has to be automatic filled in on the 2 selectable criterias. (in example above, we must seek the information of: Audi, Non Active. Type + Fuel: has to be "A3 UNL", Plate: has to be "ABC-333-5", and so further on..)

I tried many times vith INDEX and MATCH but i can't fix the formulas on the 2 criterias.
Important: I can't use array function in formula an i don't want to use VBA.

Someone smart enough to fix the formulas for the fields?

Allready Big Thanks for your help,

 

[DanteAmor]

If in the second table, you separate the "Type + Fuel" concepts into separate rows, then you could have a unique formula:
(It is also considering the helper column.)

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M
1	Status	Mark	Type	Fuel	Plate	KM	Omnium	Omnium Until	Winter Tyres	Color	Remarks		Helper Column
2	Active	BMW	320	G	ABC-123-5	60000	Yes	30/06/2020	No	White			1
3	Non Active	Mercedes	A-Class	UNL	ABC-321-9	32000	No	31/12/2019	No	Grey			1
4	Active	Audi	A6	G	ABC-222-2	51000	Yes	25/05/2020	Yes	Black			1
5	Non Active	Audi	A3	UNL	ABC-333-5	20	Yes	25/08/2020	Yes	Red			1
6	Active	VW	Passat	G	ABC-555-3	25000	No	None	No	White			1
7	Non Active	Audi	B10	UNL2	XYZ-222-2	100	Yes	25/05/2020	Yes	Black			2
8	Non Active	Audi	XXX	YYYY	ZZZZ	99	YES	25/10/2020	NO	WHITE			3
9
10
11
12	Audi	Non Active	3
13	Type	A3	B10	XXX
14	Fuel	UNL	UNL2	YYYY
15	Plate	ABC-333-5	XYZ-222-2	ZZZZ
16	KM	20	100	99
17	Omnium	Yes	Yes	YES
18	Omnium Until	44068	43976	44129
19	Winter Types	Yes	Yes	NO
20	Color:	Red	Black	WHITE
Sheet2 (2)

Cell Formulas
Range	Formula
M2:M8	M2	=COUNTIFS($A$2:A2,A2,$B$2:B2,B2)
C12	C12	=COUNTIFS('Sheet2 (2)'!A2:A8,B12,'Sheet2 (2)'!B2:B8,A12)
B13:E20	B13	=IFERROR(LOOKUP(2,1/(($A$2:$A$8=$B$12)*($B$2:$B$8=$A$12)*($M$2:$M$8=COLUMNS($B$12:B12))),INDEX($C$2:$J$8,0,ROWS($A$13:A13))),"")

 

[VeKa27]

DanteAmor and Kweaver, Thanks for the replys. It helped me out of my problem.
Glad helpfull people as you exist..