Using Data Validation
 

I have a main worksheet with a Data Validation Drop Down List. There is
another worksheet where I have the list/s of information, I have called
INFO1. Let's say the first cell in the main sheet is K7. The data on the
INFO1 worksheet is in the following format:
A B
1 Red R
2 Green G
3 Blue B
4 Purple P
When I click on K7, I get the drop down list of A1 thru A4, and making a
selection returns the value in column A I clicked on. What I want to happen
is when I click on a cell in column A it will then return the value in
column
B only in cell K7. i.e. click A2 returns G in cell K7. The range I would
like this to work in is K7.K56. Hope I have asked this correctly. thanks
for the help......... Bill

Using Data Validation
 

You would need to use event code, like Worksheet_Change.

Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Range("A:A") Is Nothing Then
Range("K7") = Target.Offset(0, 1).Value
End If
End Sub

Copy this snippet to you sheet code module by right clicking
the sheet name tab, then click View Code in the pop up menu
to open the code window.



"retired bill" wrote in message
...
I have a main worksheet with a Data Validation Drop Down List. There is
another worksheet where I have the list/s of information, I have called
INFO1. Let's say the first cell in the main sheet is K7. The data on the
INFO1 worksheet is in the following format:
A B
1 Red R
2 Green G
3 Blue B
4 Purple P
When I click on K7, I get the drop down list of A1 thru A4, and making a
selection returns the value in column A I clicked on. What I want to
happen
is when I click on a cell in column A it will then return the value in
column
B only in cell K7. i.e. click A2 returns G in cell K7. The range I would
like this to work in is K7.K56. Hope I have asked this correctly. thanks
for the help......... Bill