if function

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Richard - 27 Jan 2007 04:13 GMT

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 to this Message

Ron Rosenfeld - 27 Jan 2007 04:34 GMT

>How do you folks write this function if cell A1=B1, then cell D1=C1?

D1: =IF(A1=B1,C1,"undefined")

--ron

Reply to this Message

Tim Otero - 27 Jan 2007 09:15 GMT

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

> How do you folks write this function if cell A1=B1, then cell D1=C1?
>
[quoted text clipped - 3 lines]
> 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 to this Message

Rate this thread: