software

I have a protected form to be filled out. In one column I have a drop-down
list with 25 things in it to choose from. In adjacent column is dollar
amount to be added. One of these 25 things when I choose it, I want the
adjacent cell to be protected so it can't be filled in. I have looked in the
quot;ifquot; function, but can't figure out how to do this. Does anyone have any
ideas?

I'd build a table on another worksheet that had the 25 items in A1:A25 and the
associated amount in B1:B25.

I'd use data|validation to show that list of 25 items.

And then I'd use =vlookup() to return the amount.

=if(a1=quot;quot;,quot;quot;,vlookup(a1,sheet2!a:b,2,false))

Debra Dalgleish has some nice instructions for you:
www.contextures.com/xlDataVal01.html
and
www.contextures.com/xlFunctions02.html

Matilda wrote:
gt;
gt; I have a protected form to be filled out. In one column I have a drop-down
gt; list with 25 things in it to choose from. In adjacent column is dollar
gt; amount to be added. One of these 25 things when I choose it, I want the
gt; adjacent cell to be protected so it can't be filled in. I have looked in the
gt; quot;ifquot; function, but can't figure out how to do this. Does anyone have any
gt; ideas?

--

Dave Peterson