vlookup for a value that appears more than once in a column.

hello guys
i want to be able to pull out the rows that have the same value x for example:

oUliuQn.png

i want to extract just the rows with the number 3 in the title column with all its columns (extract the row). so i get:

8Cktb53.png

please help me out with this. thank you.

Assuming your data is on Sheet1:

Use this array formula in in A2 Sheet2. Pull formula down and across

=IFERROR(INDEX(Sheet1!A:A,SMALL(IF(Sheet1!$A$2:$A$8=3,ROW(Sheet1!$A$2:$A$8)-1),ROWS(A$1:A1))),"")


...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer. Press F2 on that cell and try again.

This should work for you:

Thank you for the feedback!

Please mark thread as "Solved" if your issue has been resolved. (Selecting Thread Tools -> Mark thread as Solved).