| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If logic for text
Hi,
In col B and col C type these values 1 High 11 Medium 16 Low Now you can use the VLOOKUP formula =vlookup(A5,B2:C4,2) -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Sri Harsha" <Sri wrote in message ... Hi, I am creating a defect log in which i am trying to capture the severity of the defect based on its type. I have about 18 types of defect. What i want now is if the user selects 1-10 defects, the defect severity should be High and from 11-15, it has to be medium and from 16-18, it has to be low. Can some one help me with this formula please? Please note that this has to look at a cell with TEXT and not a value. Regards, Sri Harsha. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using COUNTIF for multiple text data creating a logic statment | Excel Worksheet Functions | |||
| I Then logic help | Excel Worksheet Functions | |||
| Can an Excel logic function change the color of a cell or text? | Excel Worksheet Functions | |||
| IRR Logic | Excel Worksheet Functions | |||
| IF THEN LOGIC | Excel Discussion (Misc queries) | |||
![Ashish Mathur[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
