+ Reply to Thread
Results 1 to 2 of 2

CHOOSE Formula

  1. 08-30-2018, 03:28 PM #1
    Aphyx
    Aphyx is offline
    Registered User
    Join Date
    06-05-2012
    Location
    London, Canada
    MS-Off Ver
    Excel 2003
    Posts
    40

    CHOOSE Formula

    Hi,

    I have a sheet that has approximately 50,000 Indirect formula on it... I know what some of you experts are thinking... SERIOUS SLOW DOWN because of the volitile Indirect formula always calculating... VERY PAINFUL.

    I have found that Choose is a better alternative.

    My issue is that I am having trouble converting the Indirect to Choose or building the Choose choices to be actual cell references like I did with the Indirect formula.

    Any Suggestions on how I can build the Choose formula using values stored in other cells on another sheet?

    I thought it would be simple but apparently not.

    On Sheet2 I have this
    =Indirect(A2&B2)
    where Sheet2!A2 = "Sheet1!" and Sheet2!B2 = "A1:B1"

    I've tried this
    =Choose(1,A2&B2)
    without success

    I can't seem to get Choose to recognize cells A2 & B2 as cell references to a location on another sheet.

    Suggestions?
    Reply With QuoteRegister To Reply
  2. 08-30-2018, 04:05 PM #2
    6StringJazzer
    6StringJazzer is offline
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: Choose Formula

    For what you have shown here, you must use INDIRECT. CHOOSE cannot do what you are trying to make it do.

    But you are only showing us a single formula. You may get a better answer if you take a step back and tell us overall what you are doing. We may have a better approach to solving your problem that will not require INDIRECT. In particular, your data design may need a second look.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Two validations: first choose the sheet (1-5), then choose the option
    By bee88 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-17-2014, 08:12 AM
  2. Need help with a choose from a list formula
    By afe5026 in forum Excel General
    Replies: 2
    Last Post: 10-03-2014, 06:33 PM
  3. [SOLVED] Formula help to choose lowest cost from multiple vendors and then choose vendor
    By roland_arv in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 07-27-2013, 07:48 PM
  4. [SOLVED] formula to choose top 5
    By AGA in forum Excel General
    Replies: 2
    Last Post: 04-26-2012, 11:03 AM
  5. [SOLVED] If formula to choose which value to use
    By manharji in forum Excel General
    Replies: 4
    Last Post: 03-03-2011, 05:36 PM
  6. Using the CHOOSE formula
    By tropezfn in forum Excel General
    Replies: 1
    Last Post: 09-28-2006, 11:21 AM
  7. IF, OR, CHOOSE, TRUNC Help with formula please
    By Tomkat743 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-21-2006, 07:45 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1