+ Reply to Thread
Results 1 to 1 of 1

Returning values from row and column based on 2D array

  1. #1
    Registered User
    Join Date
    03-22-2012
    Location
    Jersey
    MS-Off Ver
    Excel 2007
    Posts
    1

    Returning values from row and column based on 2D array

    Hi, i'm new to this forum, and have problem in excel I cant solve!

    So far, i find the MAX of a 2d array.

    What i want to find out is the RRP (column) and the batch (row) size used to calculate that max value in the array.

    So far i have tried =INDEX(Results!$B$2:$SH$2,MATCH(Calc!$B$1,Results!$B$2:$SH$502,0)) for the Column lookup.

    On both row and column it returns #N/A which i cant seem to solve.

    I have attached the workbook sample so if anyone can help it would be much appreciated!
    Excel 2007. Although it looks to 500 row's and column's, I have had to delete them because the file is too big, so there are only 50 now.

    Luke
    Attached Files Attached Files
    Last edited by lukey0; 03-22-2012 at 04:02 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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