Show up where?
In another cell?

Say the drop downs are in ColumnA.
Try this:

=--OR(A1={"AC","LV"})

And copy down as needed.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"Reegan" wrote in message
...
I have a spreadsheet that has a column which had a drop down menu of codes
(i.e. LV, DE, TR, AC, RT).

I would like to come u"p with a formula that will assign a number based on
the corresponding column's code.

For example:
If a column contains the code of AC or LV I would like "1" to show up.
If a column contains the code of DE, TR or RT I would like "0" to show up.

Any help would be GREATLY appreciated.

Thanks.