I need to populate a data validation drop down box with multiple choices based on a cell value of the adjacent cell.


I need to be able to do a vlookup of a cell, using the result, create a Data Validation drop down box that has multiple choices from a seperate sheet. Ex

Sheet1                                 Sheet2

 A                B                         A          B

1. Steve     Here                   Steve    DV Box with Here, There, Everywhere      as choices

2. Steve     There                 Bob       DV box with Going, Gone                         as choices

3. Steve     Everywhere

4. Bob        Going

5. Bob        Gone

This is a very very long list on Sheet1, Column's A & B .    

I hope this makes sense.                      


Answer the Question

You must create an account to use the forum. Create an Account or Login