Dhanesh Nair
New Member
Hi There
Have a query,
I have a presentation to management.
There are 20 people with different skills ( each skill being given a number 1-40).
The first column has the name and the second column has the skills in one cell with spaces separating the skills numbers. as per attached.
Is there a way a look up could be structured wherein I input number 4 and it brings up all the people with that skill ( #4)
I have attached a copy of the sheet I am working on.
Please let me know if you need any clarification.
I have tried a few things but somehow...the skills being in one cell is causing a problem.
Thanks in advance.
Have a query,
I have a presentation to management.
There are 20 people with different skills ( each skill being given a number 1-40).
The first column has the name and the second column has the skills in one cell with spaces separating the skills numbers. as per attached.
Is there a way a look up could be structured wherein I input number 4 and it brings up all the people with that skill ( #4)
I have attached a copy of the sheet I am working on.
Please let me know if you need any clarification.
I have tried a few things but somehow...the skills being in one cell is causing a problem.
Thanks in advance.