hopefully a quck and easy formula

[Bemo]

<TABLE class=tborder id=post2820135 cellSpacing=0 cellPadding=6 width="100%" align=center border=0><TBODY><TR vAlign=top><TD class=alt1 id=td_post_2820135 style="BORDER-RIGHT: #ffffff 1px solid">All

i have a sheet the i want to establish a formula to automatically add a text comment based on the values in a column.

Column D has values of 1-4. I would like to have the following post in Column E.

if D2 = 1 = No Activity
if D2 = 2 = Activity Noted
if D2 = 3 = Missing/Replaced
if D2 = 4 = Damaged/Replaced

i would like for it to continue from D2 through D40

I have tried the =ifnumber(search... and can only make it work for the value of 1.

any help would be greatly appreciated

Thanks

Byron
<!-- / message --></TD></TR><TR><TD class=alt2 style="BORDER-RIGHT: #ffffff 1px solid; BORDER-TOP: #ffffff 0px solid; BORDER-LEFT: #ffffff 1px solid; BORDER-BOTTOM: #ffffff 1px solid">

</TD><TD class=alt1 style="BORDER-RIGHT: #ffffff 1px solid; BORDER-TOP: #ffffff 0px solid; BORDER-LEFT: #ffffff 0px solid; BORDER-BOTTOM: #ffffff 1px solid" align=right><!-- controls -->

</TD></TR></TBODY></TABLE>

 

[CWatts]

Start in E2 and copy it down to E40.

=LOOKUP(D2,{1,2,3,4},{"No Activity","Activity Noted","Missing/Replaced","Damaged/Replaced"})

 

[scottylad2]

<table class="tborder" id="post2820135" align="center" border="0" cellpadding="6" cellspacing="0" width="100%"><tbody><tr valign="top"><td class="alt1" id="td_post_2820135" style="BORDER-RIGHT: #ffffff 1px solid">
Column D has values of 1-4. I would like to have the following post in Column E.

i would like for it to continue from D2 through D40


<!-- / message --></td></tr><tr><td class="alt2" style="BORDER-RIGHT: #ffffff 1px solid; BORDER-TOP: #ffffff 0px solid; BORDER-LEFT: #ffffff 1px solid; BORDER-BOTTOM: #ffffff 1px solid">
</td><td class="alt1" style="BORDER-RIGHT: #ffffff 1px solid; BORDER-TOP: #ffffff 0px solid; BORDER-LEFT: #ffffff 0px solid; BORDER-BOTTOM: #ffffff 1px solid" align="right"><!-- controls -->

</td></tr></tbody></table>

not sure what you mean by this, all the values you have are aimed at D2 and if any of the numbers 1 - 4 are present then you want the stated return.

In D3, are we still lookiing at the same criteria?

 

[Just Jan]

E2 =CHOOSE(D2,"No activity","Activity noted","Missing/Replaced","Damaged/replaced")

 

[Bemo]

Thanks to CWATTS from Maine. A Southern Man appreciates you very much!!!!!