+ Reply to Thread
Results 1 to 2 of 2

Excel 2007 : Calling functions based on input values in Excel 07 (functions array?)

  1. #1
    Registered User
    Join Date
    02-10-2012
    Location
    Indiana, USA
    MS-Off Ver
    Excel 2007
    Posts
    5

    Calling functions based on input values in Excel 07 (functions array?)

    Hello, everybody. I am a fairly experienced Excel user, but not an expert. I have a spreadsheet that contains 32 numerical values (1-32). I also have 32 unique functions that are matched up to numerical values. What I am trying to come up with is a way to have a cell return the result of a function that is called based on the input value. I've attached an extremely simplified example of what I am trying to do. In the example spreadsheet, Column A represents my numerical values (limited to 5 for the example). Column B represents the unique formula that coincides with each numerical value. Cell C7 has a value of 7. Column D represents the input values. Note that they are not in numerical order. Column E represents the value that I hope to get back after Excel figures out that for an input value of 1, I want it to apply the formula in cell B3. I've come up with quite a few ways to get the text of the formula to return in the cells of Column E, but what I really want is a way to get the text of the formula with an actual equals sign so that the formula calculates the result. I'm not opposed to adding columns where multi-step operations are conducted. Obviously, I could handle 5 values from the example spreadsheet with an IF formula, but like I said, I've got 32 values and my formulas in my actual spreadsheet are more complex than in the simplified example. Thanks in advance for any help that comes in.
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    12-15-2009
    Location
    Chicago, IL
    MS-Off Ver
    Microsoft Office 365
    Posts
    3,177

    Re: Calling functions based on input values in Excel 07 (functions array?)

    Try UDF. I created a custom function called XYZ with 2 inputs required. X is the value, y is the item #

    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1