retrieving information

H

hsb101

In one worksheet i have many columns with information which is names an
skills of that name in a corresponding row, I want to search and vie
this information, im using a match zero formula however I can only ge
one answer when I would like all of them. How can I achieve this?

hope someone can hel
 
H

hsb101

i switched to lookup formula but still getting one result (the fina
one) - but their is multiple answers in one column

i am basically matching a text to a cell and need to retriev
information from a row that matches the cel
 
Top