+ Reply to Thread
Results 1 to 3 of 3

Selecting data in an array based on input variables

  1. #1
    Registered User
    Join Date
    03-11-2018
    Location
    Tampa, Florida
    MS-Off Ver
    2016
    Posts
    71

    Selecting data in an array based on input variables

    So, I have created a sizeable array. Not sure how to word my question since I rarely work with arrays. I'm wondering if it is possible to select an array cell that represents the intersection of my horizontal input cell (header row) and the vertical input cell (column 1)? I have attached a sample spreadsheet for your review.
    Attached Files Attached Files

  2. #2
    Forum Expert XLent's Avatar
    Join Date
    10-13-2010
    Location
    Essex, UK
    MS-Off Ver
    various
    Posts
    2,115

    Re: Selecting data in an array based on input variables

    given your criteria I think the return should be 2 1/2 F, rather than 2 F?

    Formula: copy to clipboard
    Please Login or Register  to view this content.

    note: tilde ~ is a special character in XL and so to use as a literal value you must prefix, ironically, with an additional ~

  3. #3
    Registered User
    Join Date
    03-11-2018
    Location
    Tampa, Florida
    MS-Off Ver
    2016
    Posts
    71

    Re: Selecting data in an array based on input variables

    Thank you XLent, that works beautifully. And, you were right about the return also (evidently I've been staring at numbers too long!)

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Array to find cell data based on two variables
    By gassiusmax in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 11-17-2015, 04:49 AM
  2. Input Box for Selecting Multiple Cells - Array
    By Excel Guy 123 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-21-2013, 12:49 PM
  3. [SOLVED] finding an output from 5 variables in an array using exterior input user variables
    By Allsort in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-09-2013, 11:16 AM
  4. Selecting Data Based on User Input
    By famousp in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-23-2009, 04:16 PM
  5. Making a calculation based on two input variables
    By Rynofasho in forum Excel General
    Replies: 1
    Last Post: 04-29-2009, 05:00 PM
  6. Replies: 2
    Last Post: 05-14-2008, 04:57 PM
  7. Selecting patient data based on multiple variables to calculate mean and SD
    By Andrew! in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-01-2008, 02:14 PM

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