software

I have a spread sheet that has a several columns with a text Value of
quot;Nonequot;, Slight/Moderatequot;, quot;Severequot;. What I want to do is create a Macro
or something that if it sees say a Cell with quot;Severequot; in it it will
change the Cell value to 0--
mseifert_99
------------------------------------------------------------------------
mseifert_99's Profile: www.excelforum.com/member.php...oamp;userid=30573
View this thread: www.excelforum.com/showthread...hreadid=508331You can do this with Find amp; Replace. Highlight the cells or columns
where you want to make this change, then click Edit | Replace (or just
do CTRL-H). In the panel that pops up you should enter quot;Severequot;
(without the quotes) in the Find What box, enter 0 in the Replace With
box and then click Replace All.

Hope this helps.

PeteTry this:

originallookup
codenumbercodenumber
None1Slight/Moderate2
Severe0None1
Slight/Moderate2Severe0

Your table of codes/numbers in A3:B5
The values you want to translate in e.g. D35
In E3 enter:
=IF(ISNA(VLOOKUP(D3;$A$3:$B$5;2;FALSE));quot;???quot;;VLOO KUP(D3;$A$3:$B$5;2;FALSE))
Copy down as required

That will translate any code that is in the table to the accorsing
number.

Hans

Sorry for the crap formatting above