for your first one in J3, use this array formula...
=INDEX($A$2:$A$30,MATCH(1,(L3=$C$2:$C$30)*(M3=$D$2:$D$30),0))
Activate it by pressing ctrl+shift+enter at the same time so the {} appear on either end of it, you cannot put them in your self as it will not function.
for the other columns just change the $A$2:$A$30 to B for the area, E for path, F for UFID, G for left max and H for left dista.