Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
writing a formula to distinguish a letter and a number
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 "noel" wrote: 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
writing a formula to distinguish a letter and a number
noel,
I think validation and a drop down might be your best bet here. Or an event macro using VBA that changes your input after leaving the cell. Unless of course the input is in one cell and the desired output is in a different cell... Beege noel wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding a number to a letter of the alphabet to get a letter | Excel Worksheet Functions | |||
formula converting number to column letter 26 | Excel Worksheet Functions | |||
Help to write a formula using a letter value and a number value | Excel Worksheet Functions | |||
change headers from letter to number/number to letter | Excel Worksheet Functions | |||
column header changed from letter to number, how return to letter | Excel Discussion (Misc queries) |