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?

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