Creating a service catalogue view using Excel/VBA

[Princezz]

Hi Excel experts,

I need to create a service catalogue view for my database. It has 4 columns,

1. portfolio owner
2. division owner
3. L2 level
4. Service #

Now, when the user selects portfolio owner & division owner, the table should display all L2 level activities & Service #. please note each row is not unique i.e a record can have (1),(2) &(3) data fields common and only have (4) as a different value. Reiterating, on selecting (1) & (2), the table should show (3) & (4) data fields. In some cases, (3) isn't recorded, so it should only display (4).

I tried using vlookups and creating ranges..but its just not giving the view I want.

Pls help!

 

[Chihiro]

Your file seems to be corrupt. Can you re-upload?