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

"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.

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

On Fri, 22 Feb 2008 12:02:39 -0800 (PST), 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.