Lookup function

[David]

SHEET 1 In col "A1:A3" I have 1, 2, 3. In col "B1:B3" I
have A, B, C.

SHEET 2
COL "A" has many cells with 1, 2, or 3 in them. I desire
the adjacent cel in col "B" to automatically enter A, B,
or C depending on the value in col "A" and using the list
on SHEET 1.

Thanks
Dave

 

[Paul]

SHEET 1 In col "A1:A3" I have 1, 2, 3. In col "B1:B3" I
have A, B, C.

SHEET 2
COL "A" has many cells with 1, 2, or 3 in them. I desire
the adjacent cel in col "B" to automatically enter A, B,
or C depending on the value in col "A" and using the list
on SHEET 1.

In Sheet2!B1 put this formula:
=VLOOKUP(A1,Sheet1!$A$1:$B$3,2,0)
and copy this down as far as required.