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

"hacdunqh" wrote:

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.