How can I find only rows that match 2 columns among multiple columns with same values?

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.

if you need help with activating an array, go to this link and post #17 where I put in three PDFs to show how to activate it...
https://www.excelforum.com/excel-gen...r-sheet-2.html

after giving it a little thought, once you've used that formula in J3, it would be easier for you to use these vlookup formulas in K, N, O, P and Q as it isn't an array formula. Because your sheet showed individual UFID numbers.
in K3 =VLOOKUP(J3,$A$2:$B$30,2,FALSE)
then in N3 and dragged right ...
=VLOOKUP($J3,$A$2:E$30,COLUMN(E$1),FALSE)
so the only array you would need is the first one.