Dependency Matrix

[spgarg04]

Hi,

I have a problem data is like this

Project Name Project 1 Project 2 Project 3 Project 4 Project 5
Project 1
Project 2 H
Project 3 H
Project 4 M
Project 5 M
Project 6 M
Project 7 H
Project 8 L
Project 9 L
Project 10 L

Now in another sheet i want to make a drop down where when i select

Project 1. it should display the result like this

H M L
project 2 Project 4 Project 8
project 3 Project 5 Project 9
Project 7 Project 6 Project 10

so basically it should display the project names which are related to project 1 and H, M and L

would appreciate any help.

thanks