Looking for data in spreadsheet and retrieving info from same row

[seis66]

Hi everyone!
Wow, first time in a forum in more than 5 years... always glad to see people still interact this way

I am trying to create a search grid. What I would like to know to do is the following:

1.- I would like to search for specific data based on keywords within a spreadsheet.
2.- For instance, I want to look for "marketing", "web", "digital", "mobile" within a spreadsheet.
3.- Whenever excel finds any of those terms, it should retrieve info from the row it found the keyword.
4.- For instance, lets say excel finds the word "marketing" in cel D9. I want excel to retrieve info from from that same row, but from columns A, C, D, E and J. This needs to be copied in a second spreadsheet.
5.- The keywords I'm looking for will repeat themselves in different rows - for instance, "marketing" could it in row 1, 8, 24, 35, etc. I want excel to retrieve specific info from all the instances where it finds the keyword.
6.- In case the above is possible: how should I do it for multiple keywords? lets say "whenever you find the words 'marketing', or 'web', etc... take data from cells D1,

Have I explained myself clear enough?

thanks a lot for your help, guys!

[Pete_UK]

In this Forum you can attach an Excel file to one of your posts - the FAQ describes how to. This would make your description a bit easier to follow.

Pete