Data Validtion
 

I have a column in my worksheet in which I am using data validation with
V-lookup from another worksheet. When I click on the drop down list in the
column it of course shows the listing from the other worksheet. In the next
column in the lookup worksheet I have a reference code for the item in the
first column. What I would like to do, is when someone clicks on the drop
down list in my MAIN worksheet, and selects a value, I would then like it
replaced with the reference code that corresponds with the value being
clicked on. If this does not make sense, please let me know and I will try
to explain it again in another way. Thanks