Help in how to do this?

I am new in excel and I wanted to organize the data but I cannot find the right function to make it work.

Need a function to search through Column E for a value and return the texts from Columns A, B, C, D into a new set of columns whenever it strikes a match.

A B C D E Appl Text Text Text 3 Grap Text Text Text 2 Pear Text Text Text 1 Berr Text Text Text 2 Ora Text Text Text 1

For example searching for the value of **3** in Column E and returning the values into something like:

A B C D Appl Text Text Text Ban Text Text Text

Can you just **filter** on column E to get all the rows with 3?

For a formula approach, assuming your first table in A1:E5 try this formula in G1

`=IFERROR(INDEX(A$1:A$5,SMALL(IF($E$1:$E$5=3,ROW(A$1:A$5)-ROW(A$1)+1),ROWS(G$1:G1))),"")`

confirmed with CTRL+SHIFT+ENTER and copied across and down as far as required - once matching rows run out you get blanks

see example here

Note: IFERROR requires Excel 2007 or later version, but this can be modified to work with earlier excel versions