Results 1 to 8 of 8

Index and Match on multiple similar tables

Threaded View

  1. #1
    Registered User
    Join Date
    08-06-2020
    Location
    India
    MS-Off Ver
    365
    Posts
    2

    Index and Match on multiple similar tables

    Hello,

    I need to use Index and Match function for this problem.
    Need to select the specific table using the "customer type" parameter and then a value inside that table by using "region" and "shipping" method. Parameters can be change using dropdown.

    Excel file Attached

    eg
    Attachment 689834

    Need to find Shipping per unit using the tables below
    Attachment 689835

    Thanks!!!
    Attached Files Attached Files
    Last edited by infinia; 08-06-2020 at 03:14 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 13
    Last Post: 04-22-2020, 06:44 AM
  2. [SOLVED] INDEX / MATCH using multiple tables depending on values?
    By nostrum in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 06-21-2019, 05:15 AM
  3. Index match with multiple similar columns/rows?
    By sh4d0w1ink in forum Excel General
    Replies: 3
    Last Post: 06-05-2019, 03:27 PM
  4. How to use INDEX MATCH in unison with AVG, MIN, MAX etc across multiple tables?
    By TheBananaGuy in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-29-2018, 12:48 AM
  5. [SOLVED] INDEX MATCH MATCH with multiple layered tables
    By acenewbie in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 03-07-2018, 11:51 AM
  6. Using index match to find terms on multiple tables?
    By tsiguy96 in forum Excel General
    Replies: 3
    Last Post: 08-12-2015, 05:25 AM
  7. Need data cross-referenced in multiple tables: VLOOKUP vs. Match vs. Index
    By James McMurray in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-05-2008, 02:53 PM

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