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 |