Lookup function

  • Thread starter Thread starter David
  • Start date Start date
D

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
 
David said:
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.
Click to expand...

In Sheet2!B1 put this formula:
=VLOOKUP(A1,Sheet1!$A$1:$B$3,2,0)
and copy this down as far as required.
 
=VLOOKUP(A1,Sheet1!A:B,2,FALSE)
will allow you to add to the list on sheet 1

=VLOOKUP(A1,Sheet1!A1:B3,2,FALSE)
will require you to revise formula if you add to sheet 1

Dan E
 
Back
Top