Validation list that fills in something else

[katiapro93]

Hello everyone, I have been looking around to see if I can get an answer to what I think will be easy, but I can't find anything. Here is my problem. I know how to do a validation list but I need the list to show something and when I pick it, I want it to fill in something else. Example:

A B C
1 1231 Joe Collins 1231 -Joe Collins
2 1521 Joe Smith 1521 -Joe Smith

I want my validation list to show what is on column "C", but when selected, I want it to write what is on column "B".

Any suggestions. I am using Excel 2007.

 

[villy]

Sub hides()
With WorksheetFunction.Application
    If Not IsError(.Index(Range("C1:C10"), .Match(Range("F2"), Range("C1:C10"), 0), 1)) Then
        Range("F2").Value = .Index(Range("B1:C10"), .Match(Range("F2"), Range("C1:C10"), 0), 1)
    End If
End With
End
End Sub

Try this

 

[katiapro93]

I am assuming these codes are through VBA and I am not sure how to do it. Can you guide me step by step. I am sorry.