Thread: Simple question
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
hacdunqh hacdunqh is offline
external usenet poster
 
Posts: 1
Default Simple question

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.