Results 1 to 14 of 14

INDEX MATCH Over Seventeen Tables

Threaded View

  1. #1
    Registered User
    Join Date
    01-01-2020
    Location
    Oxford
    MS-Off Ver
    O365 (V2307)
    Posts
    31

    INDEX MATCH Over Seventeen Tables

    Hi,

    I have 17 tables of data - each in exactly the same size and format - the y and x axis have values you read down and along to find the correct value at the intersection of s and y axis. Y is 1-90 in increments of 1, x axis is 1-180 in increments of 5.

    I have another worksheet in the same workbook with 3 cells (A1, B1, C1) containing data that constantly changes. The value in A1 is always 1-17 and tells me which of the 17 tables I need to go to. The values in B1 (y axis) and C1 (x axis) direct me within the correct table to the value in the cell at the relevant intersection of x and y which is the value I need returned.

    So I need a formula that will select the correct table to Index Match Match based on A1, then perform an Index Match Match based on B1 and C1 to return the value I need.

    I have tried all sorts of Index Match with indirect and can't get the formula to work. I was wondering if anyone would mind helping? Is this a job for VBA?
    Last edited by AliGW; 06-03-2020 at 01:07 AM. Reason: Title causing database error - updated.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Change data in temporary created file to value
    By MagicMan in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-27-2019, 07:48 AM
  2. Change the Name of a Temporary File
    By whisperinghill in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-30-2007, 03:26 PM
  3. Mag - Please change your title
    By mag in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-04-2007, 12:09 PM
  4. Change Title Bar
    By praptisahni in forum Excel General
    Replies: 1
    Last Post: 02-28-2006, 11:25 AM

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