select dependent cells in the result cell
 

i have list in the "H" Column, which has (Critical, major, minor).

A column has AU01 and so on...

i wanted to list all the A column values for critical.

ex: if H2, H12 and H 23 are selected with critical.
and in the result cell, it should display AU02,AU12 and AU23.

please give me solution as early as possible...

thanks a lot in advance...

regards
Gireesha