| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
avoid nested IFs with another function
I have an array comprised of two columns and and 8 rows. The left column
contains an ascending list of numbers -- 91, 181, 366, etc. The right column contains a corresponding text entry. I want to compare if a value is less than the number in the left column of the first row. IF the compared value matches the criteria, pull the text in right column, but if not, move on to the next row, perform the comparison again to the number in the second row and either pull the text in the right column or move on to row three, and so on. 91 AGING 181 MILD 366 MEDIUM 732 SHARP - 1YR 1098 SHARP - 2YR 1464 SHARP - 3YR 1830 SHARP - 4YR 2195 SHARP - 5YR & MORE Can I avoid nesting IF functions? I will have other items that will have more than 8 rows. I hope this question makes sense. Thanks for helping. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| using sum function,can I avoid calculating hidden rows | Excel Worksheet Functions | |||
| ? avoid changing sum function as rows added? | New Users to Excel | |||
| how can avoid considering of blank cells in IF function | Excel Worksheet Functions | |||
| How do you avoid duplicates when using the randbetween function? | Excel Worksheet Functions | |||
| Avoid geeting function GETPIVOTDATA | Excel Discussion (Misc queries) | |||
Threaded Mode
