Results 1 to 9 of 9

Data from multiple arrays

Threaded View

  1. #1
    Registered User
    Join Date
    11-03-2009
    Location
    house
    MS-Off Ver
    Excel 2007
    Posts
    3

    Data from multiple arrays

    Using 3 reference cells to determine which table, row, column; I need to return a single value from 9 different arrays/tables. Can this be done? Am I looking at the wrong Function? Attached is an example.

    (I marked solved to early. The solution worked fine for the example I gave, but not for my actual problem. In my example, the rows and columns are text. What I need is a solution that will work, if numbers replaced the text. The rows will be labeled: 1,3,5,10.....and the columns 3/4, 1, 1 1/4, 1 1/2, 2..... an exact match will be needed for the column and closest match for the row.)
    Attached Images Attached Images
    Attached Files Attached Files
    Last edited by Inkling; 11-06-2009 at 09:36 PM.

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