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.