| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula Simplifications Using Nested If, Indirect & Address Functi
After reviewing some previous posts, I've come up with the following
function. Ideally, I would like to give it a Name reference, but it is too long. Any suggestions for simplifying and shortening? The formula looks at the left adjacent cell for location codes that correspond to location descriptions. The column locations have the potential of changing so I needed a solution that could dynamically change without a fixed reference point. Let me know if you need any other information. Thank you in advance for any assistance. =IF(INDIRECT(ADDRESS(ROW(),COLUMN()-1))="O","Regional / Highland Ave",IF(INDIRECT(ADDRESS(ROW(),COLUMN()-1))="OMV","Maryville / Armory Place",IF(INDIRECT(ADDRESS(ROW(),COLUMN()-1))="OWK","West / Cedar Bluff",IF(INDIRECT(ADDRESS(ROW(),COLUMN()-1))="OSV","Sevierville / Bradford Square",INDIRECT(ADDRESS(ROW(),COLUMN()-1)))))) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Allow EXCEL INDIRECT(ADDRESS()) and INDIRECT(RANGE()) functions | Excel Worksheet Functions | |||
| Sum(indirect(Address...... | Excel Worksheet Functions | |||
| INDIRECT and ADDRESS | Excel Worksheet Functions | |||
| using INDIRECT(ADDRESS(...)) | Excel Discussion (Misc queries) | |||
| nested Indirect to other WS | Excel Worksheet Functions | |||
Threaded Mode
