VLookUp or Index-Matching

Hi,
I'm used to using VLookUp for returning a simple one value.
I''m, however, struggling with data containing around 2k rows and 7-8 columns of personnel names and various skills each resource have where I need to do VLookUP to return all matched values instead of the first matched one only. I've heard and read about Index-Matching but not sure how to use it.
For example, I'm looking to look up all personnel matching a particular skillset. Say, looking up another sheet on excel with 2k rows who have various skills. I would like my tab to return with names of all candidates having e.g. Advance Excel skills!
Thanks to anyone with help.
Heer-Ranjha

Hi Can you attach a sample please, an array formula may be needed!
Peter

Hi, I've attached sample file.
Looking at the third tab, I want to get MI in Col C and D from the first tab to tell me which resource has what skills and at what level (Col C and D respectively)
Look forward to hopefully getting a resolution soon!
Many thanks for the assistance.

ArraYy formula in C2, then dragged across

Please Login or Register  to view this content.

ARRAY formula is used

To enter ARRAY formula
Paste the formula
Press F2
Press Ctrl+Shift+Enter keys together.
Formula will be covered with{} brackets.

Thanks for your reply.
I'm, however, looking to return names of resources in Col C of the third tab. For example, If there are more than one resources with skills of 'Application Migration' then names of all those resources should be returned by the formula in Col C of 'Required Skills with Resources' tab.
Hope that makes sense!
Is that something you could help with?
Many thanks once again

@FlameRetired
Thanks for your post.
In response to your questions:

* MI I want to return will be 'Resource Names' in Col C of the 3rd tab 'Required Skills with Resources' tab. For example, if more than one person has skills of Application Migration (from the first tab which details names and skills, then I would like to see all those names appearing in Col C in the third tab. Is that possible? VLookUp will only return first found name.

I have attached a file to show what result I am looking for in the third tab.
It shows, e.g. when no one has the required skills, then value returned is N/A
If more than one person has the required skills, for example, Agile, then all three resources' names are returned in Col C of the third tab with this skill.
If possible would be great to have Resource Rating for each person in Col D as well. But it is not as important.

More interested in getting all names with the required skills to be returned in Col C of the 3rd tab
Hope this is making sense!

File attached to help with the above!
Much appreciated