View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Noel Noel is offline
external usenet poster
 
Posts: 35
Default writing a formula to distinguish a letter and a number

How do a write a forumla so that is the input is a letter, then look up
values in a table. If the input is a number, than just accept the number.

example:
Table:
a=1
b=2
c=3
Formula;
if input = a, then look up the value of a in a table, which is 1
if input =9, then just keep the input 9 as the result