LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Allow EXCEL INDIRECT(ADDRESS()) and INDIRECT(RANGE()) functions Mike Barlow Excel Worksheet Functions 7 May 21st 23 07:42 PM
Sum(indirect(Address...... Kevin Smith[_2_] Excel Worksheet Functions 3 December 2nd 09 11:28 AM
INDIRECT and ADDRESS Al Excel Worksheet Functions 4 March 13th 09 10:05 PM
using INDIRECT(ADDRESS(...)) Dave F[_2_] Excel Discussion (Misc queries) 4 January 3rd 08 07:55 PM
nested Indirect to other WS LyleF Excel Worksheet Functions 4 August 3rd 05 04:11 PM


All times are GMT +1. The time now is 02:54 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"