software

I have a drop down list of 7 phrases. How can I assign a value(1-7) on
each list so it will reflect to next cell?
Lets say the dropdown is in B2 and I want its value in C2.

Thanks.--
cardingtr
------------------------------------------------------------------------
cardingtr's Profile: www.excelforum.com/member.php...oamp;userid=27027
View this thread: www.excelforum.com/showthread...hreadid=513899Hi,

If the phrases are standard and do not change, then use a simple quot;ifquot;statement

If(B2=quot;XXXXquot;,1,if(b2=quot;ÿyyquot;,2,etc)

Hope this helps
regards
DavidC

quot;cardingtrquot; wrote:

gt;
gt; I have a drop down list of 7 phrases. How can I assign a value(1-7) on
gt; each list so it will reflect to next cell?
gt; Lets say the dropdown is in B2 and I want its value in C2.
gt;
gt; Thanks.
gt;
gt;
gt; --
gt; cardingtr
gt; ------------------------------------------------------------------------
gt; cardingtr's Profile: www.excelforum.com/member.php...oamp;userid=27027
gt; View this thread: www.excelforum.com/showthread...hreadid=513899
gt;
gt;

=(B2=quot;firstquot;)*1 (B2=quot;secondquot;)*2 (B2=quot;thirdquot;)*3 and continue for as many as
you like
--
Gary's Studentquot;cardingtrquot; wrote:

gt;
gt; I have a drop down list of 7 phrases. How can I assign a value(1-7) on
gt; each list so it will reflect to next cell?
gt; Lets say the dropdown is in B2 and I want its value in C2.
gt;
gt; Thanks.
gt;
gt;
gt; --
gt; cardingtr
gt; ------------------------------------------------------------------------
gt; cardingtr's Profile: www.excelforum.com/member.php...oamp;userid=27027
gt; View this thread: www.excelforum.com/showthread...hreadid=513899
gt;
gt;


Try something like this:

For a text value (or blank) in A1
B1: =MATCH(A1amp;quot;quot;,{quot;quot;,quot;aaaquot;,quot;bbbquot;,quot;cccquot;,quot;dddquot;,quot;eeequot;,quot;ff fquot;,quot;gggquot;},0)-1

Does that help?

Regards,
Ron--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile: www.excelforum.com/member.php...oamp;userid=21419
View this thread: www.excelforum.com/showthread...hreadid=513899
Thanks for all your suggestions. All worked. I just have to tweak it a
little.--
cardingtr
------------------------------------------------------------------------
cardingtr's Profile: www.excelforum.com/member.php...oamp;userid=27027
View this thread: www.excelforum.com/showthread...hreadid=513899