Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sorry for the vague question
-------------------------------------------------------------------------------- What I need to replace the cells that have 2-3 letters is: "Not A Defect Code!!!" I have a sheet that has many different defect codes such as: MC WP MPI,ect,ect All of these will be change to the defect code they represent. I could not figure out how to change a defect code that was improperl entered in such as: "FC": to "Not A Defect Code!!!" thank you for the help Dre -- drew ----------------------------------------------------------------------- drewd's Profile: http://www.excelforum.com/member.php...fo&userid=1474 View this thread: http://www.excelforum.com/showthread.php?threadid=26371 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sorry for the vague question
If you have the actual defect codes in a list with the abbreviation in the 1st
column and the code in the 2nd, and you've named that range CodeTable =IF(ISNA(VLOOKUP(A1,CodeTable,2,0)), "Not A Defect Code!",VLOOKUP(A1,CodeTable,2,0)) all on one line, of course. On Sun, 26 Sep 2004 22:16:16 -0500, drewd wrote: -------------------------------------------------------------------------------- What I need to replace the cells that have 2-3 letters is: "Not A Defect Code!!!" I have a sheet that has many different defect codes such as: MC WP MPI,ect,ect All of these will be change to the defect code they represent. I could not figure out how to change a defect code that was improperly entered in such as: "FC": to "Not A Defect Code!!!" thank you for the help Drew |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Newbie Question - Subtraction Formula Question | Excel Discussion (Misc queries) | |||
Copying list item (a bit less vague) | Excel Discussion (Misc queries) | |||
How do I use the "Proper" function? The instructions are vague. | Excel Worksheet Functions | |||
Replacing cells that have 2-3 letters: Sorry for the vague question | Excel Programming | |||
Macro problem. Need a vague not absolute reference | Excel Programming |