Simple question

  • Thread starter Thread starter hacdunqh
  • Start date Start date
H

hacdunqh

Column A is composed of numbers 1 thru 5.
Column B is composed of letters A thru E.
Want user to input number is A6.
Cell A7 will interpret number intered in A6 and retrieve the adjacent
letter that goes with this #. How do I do this? Do I create a table,
IF 's? This ain't like basic programmin'. Thanks in advace.
 
Hi,

Instead of using A6 & A7 I would suggest you use another column which would
allow you to extend you list. However, with you input in A6 put this in A7

=VLOOKUP(A6,A1:B5,2,FALSE)

Mike
 
VLOOKUP table will do this for you.

In A7 enter =VLOOKUP(A6,$A$1:$B$5,2,FALSE)

Enter a number 1 through 5 in A6


Gord Dibben MS Excel MVP
 
Back
Top