Finding value from a range and if not match then find next

Hello guys,

I am having a brain freeze for following task:

Table 1 example, how the logic should be.

If(H4=A2 AND E4="D3P" AND F2="Aktiivne";
THEN B2;
ELSE if it is passive then takes number from column H and finds it in column A until it gets an active match.
THEN writes the data from column B and E after the passive device i.e into column M and N.

Table1 - All devices passive and active
Table_1_all.png

In Table 1 you can see that H4 and H5 have a matching active device of A2. So in the column M4 and N4 should be written B2 and E2... If that makes sense.

Table2 - only passive devices - aka filtered by tyyp D3P and being passive
Table_2_passive.png

Structure - might help
Structure.png
red and green triangles(like play buttons) are active devices and passive devices(green stars) are connected to them, sometimes through other passive devices(green Y)

How can it be done? Any examples of the code? OR ideas? OR questions?
I am assuming it should be in a VBA code? And i cannot code in VBA at all.

Thank you,

A

What I did myself was using index-match. I extracted step by step correct active device for passive device. Had to do it like 6 times :D