Results 1 to 13 of 13

INDEX / MATCH using multiple tables depending on values?

Threaded View

nostrum INDEX / MATCH using multiple... 06-12-2019, 01:24 PM
Bo_Ry Re: Table Data Help! 06-12-2019, 01:58 PM
José Augusto Re: Table Data Help! 06-12-2019, 02:11 PM
nostrum Re: Table Data Help! 06-12-2019, 03:42 PM
nostrum Re: Table Data Help! 06-12-2019, 03:49 PM
Bo_Ry Re: Table Data Help! 06-13-2019, 10:06 AM
José Augusto Re: Table Data Help! 06-12-2019, 04:23 PM
nostrum Re: Table Data Help! 06-13-2019, 09:34 AM
AliGW Re: Table Data Help! 06-13-2019, 09:59 AM
nostrum Re: INDEX / MATCH using... 06-13-2019, 11:53 AM
AliGW Re: INDEX / MATCH using... 06-13-2019, 11:56 AM
José Augusto Re: INDEX / MATCH using... 06-13-2019, 01:42 PM
nostrum Re: INDEX / MATCH using... 06-21-2019, 05:15 AM
  1. 06-12-2019, 01:24 PM #1
    nostrum is offline
    Forum Contributor
    Join Date
    01-12-2014
    Location
    United Kingdom
    MS-Off Ver
    Excel 2016
    Posts
    152

    INDEX / MATCH using multiple tables depending on values?

    Hi Guys,

    I have a formula I am unable to crack, hoping you can help. Attached is an example, hopefully self-explanatory but heres the run down.

    Depending on Data in C5 & C7 decides which table to use. I have used CONCATENATE as I was looking to use the INDIRECT function to point to the direction of the table required?

    Once we have the right table I need to use a Vlookup or INDEX /MATCH type of function to match both axis of the table to the data in C9 and C11 and match the data in the table!

    Hope you can help and thanks in advance!
    Attached Files Attached Files
    Last edited by nostrum; 06-13-2019 at 11:53 AM.
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Move data from 1 table to another table, then clear the original table
    By kwoltman in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-03-2019, 06:06 PM
  2. [SOLVED] Replace data in a table with same data from another table, bringing formatting with it.
    By Strykewulf in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-24-2019, 12:55 PM
  3. [SOLVED] Copy paste data from table to another table then delete data without losing formulas
    By dps9460 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-11-2019, 03:14 AM
  4. Copy data from one table and Clear and update new data into another table in another sheet
    By ammu0271 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-28-2013, 02:10 AM
  5. Data table query with min and max values derived from the data table results
    By mrvp in forum Excel General
    Replies: 0
    Last Post: 09-05-2012, 06:12 PM
  6. Export Excel data into Access table - overwrite table data
    By Jonsocks in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 03-08-2012, 12:05 PM
  7. Have Table of Data, Need Filtered Table Shown based on Column Data
    By AloPalo in forum Excel General
    Replies: 0
    Last Post: 02-20-2012, 02:53 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1