Results 1 to 3 of 3

Selecting data in an array based on input variables

Threaded View

  1. #1
    Forum Contributor
    Join Date
    03-11-2018
    Location
    Tampa, Florida
    MS-Off Ver
    365
    Posts
    105

    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

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