Hello
Please consider the table below. I try to create a dynamic dropdown list. My first dropdown list consists of all the Names in Column 1. The second dropdown list should then show the favorite Fruits 1, 2 and 3 of the chosen person. I used a named range for the first dropdown Table1[Name]) but don't know how to do the second one.
Can someone help me on this?
Thanks in advance!
<TBODY>
</TBODY>
Please consider the table below. I try to create a dynamic dropdown list. My first dropdown list consists of all the Names in Column 1. The second dropdown list should then show the favorite Fruits 1, 2 and 3 of the chosen person. I used a named range for the first dropdown Table1[Name]) but don't know how to do the second one.
Can someone help me on this?
Thanks in advance!
Name | Fruit 1 | Fruit 2 | Fruit 3 |
Alex | Apple | Banana | Orange |
Peter | Orange | Apple | Lemon |
James | Apple | Apricot | Mandarin |
<TBODY>
</TBODY>