Hello All
Have created a drop down list based on the data below in excel. Now I want to dynamically populate the data after selecting the dropdown list. So to explain further if I select LOB A in my drop down the owner P should be populated. Have been able to do this by using the simple Lookup formula, however the problem arise when it comes down to LOB H as LOB H has four different Owners and cannot be looked up using LOOKUP formula. For other LOB's there is one to one mapping however for LOB H the mapping is One to Many. Any help in this regard would be appreciated. Thanks
Have created a drop down list based on the data below in excel. Now I want to dynamically populate the data after selecting the dropdown list. So to explain further if I select LOB A in my drop down the owner P should be populated. Have been able to do this by using the simple Lookup formula, however the problem arise when it comes down to LOB H as LOB H has four different Owners and cannot be looked up using LOOKUP formula. For other LOB's there is one to one mapping however for LOB H the mapping is One to Many. Any help in this regard would be appreciated. Thanks
| LOB | Owners |
| A | P |
| B | Q |
| C | R |
| D | S |
| E | T |
| F | U |
| G | V |
| H | W |
| H | X |
| H | Y |
| H | Z |
| I | L |
| J | O |
