Here's my situation:

I have one spreadsheet with 2 columns in them.

Column 1 has values of data
Column 2 has the key codes for the data.

Example:
column 1:
Telephone
TV
Video Camera

Column 2:
A
B
C

cell A1 value: Telphone
cell A2 value: TV
Cell A3 value: Video Camera

Cell B1 value: A
Cell B2 value: B
Cell B3 value: C


I want to be able to create a macro that will search Column 2. Say I
search for the value "A"

The output should be "Telephone" into another cell.

So the steps I need is:
Macro to search for the value from Column 2
Macro to select the value in Column 1 when result is found
Macro to paste the value in Column 1 onto a new cell.

I was thinking of using a command button that you can load in using the
form function in excel.