Multiple Searching a Data Set

[seraphim666]

Dear All,

I rarely post and only use the forum out of interest and to look for solutions to problems I have and that other members may have posted on.

I recently retired and to keep my brain active, I've embarked on a project that involves Excel 2007. I like football, don't go to matches anymore, but still follow my local team from my armchair. I'm compiling a list of all the players that have appeared for the club there are 33 columns with headings e.g. name, date of birth, place born, date joined, position etc etc. that I will be populating in the coming weeks and months. See attached sample spreadsheet

What I am aiming for is to be able to search the data on a range of criteria and for information to be displayed as a result of the search, for example if I search for a name, lets say Jones and there are ten Jones in the data set I would like to see all 10 and their relevant stats, date of birth, place born, position etc.

Additionally, I would like to search, lets say, for DF (abbreviation for Defender) and a list of all the defenders and their stats to be displayed. I've look Advanced Filter but with no success.

Is this something that would be beyond Excel 2007 capabilities. I would prefer formulas to VB as I have limited knowledge of Macros.

I've come here in desperation as I've searched the internet for solutions with no success. I have managed to write a formula that includes SEARCH, RANK, COUNTIF, VLOOKUP, IFERROR but I find these limited and not able to perform the task that I want and described earlier. Or perhaps I'm not using them correctly.

Here's hoping some Excel 2007 Guru out there can point me in the right direction one way or the other and thank you for reading my post and in anticipation of a response.

Regards,
Seraphim666