Search Cell Value in Column and Populate Column Result with Row

[Verifyor]

Hi,

I wish to search a column with a cell value. I then wish to populate the cell rows with the rows from the column result.

In the example attached I want K2 result to search Cell Vale F2 in Column A.

=IF(COUNTIF($A:$A,$F2)=0,"No Match",F2)

L2 is populated with If and Then (probably not the best solution)

=IF(K2=F2,G2,"")

Cell M2 is where I get lost and don't know how to populate the data from Result in A6, B6, C6, D6 into K2, L2, M2 and N2. I've also highlight that Cell M3 & N3 differ from H3 & I3.

I would greatly appreciate some direction towards a solution.

Thanking you in advance

[PaulM100]

Not sure if I got it, but try this:
in K2, array formula, using Ctrl+Shift+Enter: =IFERROR(INDEX($F$2:$F$16,SMALL(IF(COUNTIF($A$2:$A$16,$F$2:$F$16)>0,ROW($A$2:$A$16)-1,9999999999),ROW()-1)),"")
in L2: =IFERROR(VLOOKUP(K2,$F$2:$G$16,2,0),"")
in M2: and drag to N as well:=IFERROR(LOOKUP(2,1/($A$2:$A$16=$K2)/($B$2:$B$16=$L2),C$2:C$16),"")

[Verifyor]

Thank you Paul. Your help is much appreciated!

V