Transfer data to another sheet by formulas

[YasserKhalil]

Hello everybody
I have an attachment. In Sheet1 I have data in Columns("A:E")
I need to transfer data to the sheet named "Result" based on the text "good" in Column D or in Column E
Note that there are data (good & very good) .. I need to transfer any of the two items and any of the two columns
Hope it is clear

 

[rrocker1405]

Hi Yaseer,

You can achieve this desired results in two ways. One is using advanced filter(s) or using index match like the attached file. You can choose the options from the top and based on your selection you can see the list update in the results sheet.

Hope this helps.

Kind regards,
A!

 

[YasserKhalil]

Thanks a lot Mr. Rocker for offering help
I have attached the expected results in Sheets"Result" to explain well my request
I simply need to transfer any row that has the string "good" either in column "D" or in Column "E"
Don't forget the string "good" so the string "Very good" is ok too
Thanks advanced

 

[John Jairo V]

Hi @YasserKhalil

This can be an option with formulas.

Please Comment!
I hope it helps! Blessings!

 

[YasserKhalil]

Mr. John Jairo V
Thank you very much for this magic solution. I really thank you for this great and wonderful help

Another point if it is possible ..
Say I need more than one condition..for example I need "good" string or "bad" string
Thanks advanced