Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions,microsoft.public.excel.worksheetfunctions
|
|||
|
|||
if function
How do you folks write this function if cell A1=B1, then cell D1=C1?
I created a list for 50 states, but I don't want to use the drop down arrow to select the state I want, I want to select Texas by just type in Te, then the rest letters (axas) will appear. The same way for washington state, just type the first few letters of state, and the rest will appear. Is there a way that excel allows us to do this? |
#2
Posted to microsoft.public.excel.newusers,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions,microsoft.public.excel.worksheetfunctions
|
|||
|
|||
if function
On Fri, 26 Jan 2007 22:13:15 -0600, "Richard" wrote:
How do you folks write this function if cell A1=B1, then cell D1=C1? D1: =IF(A1=B1,C1,"undefined") --ron |
#3
Posted to microsoft.public.excel.newusers,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions,microsoft.public.excel.worksheetfunctions
|
|||
|
|||
if function
Hey Richard,
I can think of several ways to do this. One would be to type all the possibilities into the 50 cells just above the desired cell, then hide the rows. A more elegant way would be to follow Debra Dalgleish's advice: http://www.contextures.com/xlDataVal10.html HTH tim Richard wrote: How do you folks write this function if cell A1=B1, then cell D1=C1? I created a list for 50 states, but I don't want to use the drop down arrow to select the state I want, I want to select Texas by just type in Te, then the rest letters (axas) will appear. The same way for washington state, just type the first few letters of state, and the rest will appear. Is there a way that excel allows us to do this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need some comments on my Utility_Move class module. | Excel Worksheet Functions | |||
Creating a Custom Excel Function to Calculate Gini Coefficients | Excel Worksheet Functions | |||
Date & Time | New Users to Excel | |||
Conversion | Excel Worksheet Functions | |||
HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions |