writing a formula to distinguish a letter and a number

  • Thread starter Thread starter noel
  • Start date Start date
N

noel

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
 
Hi,

Try this
=IF(ISNUMBER(C1),C1,VLOOKUP(C1,A1:B6,2,FALSE))

Assumptions
Input number/letter is in C1
Lookup table is in A1 to B6


Mike
 
Back
Top