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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy of excel file not showing formulal/function in the function b | Excel Discussion (Misc queries) | |||
LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
Excel - User Defined Function Error: This function takes no argume | Excel Programming | |||
Need to open the Function Arguments window from VBA for a user defined function. | Excel Programming | |||
Adding a custom function to the default excel function list | Excel Programming |