# Index and Match on multiple similar tables

1. ## 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!!!

2. ## Re: Index and Match on multiple similar tables

Try INDEX(range,row index,collumn index) with:
row index =MATCH("Customer type 30",B:B,0)+MATCH("West",\$B\$35:\$B\$41,0)
column index=MATCH("Plane",\$B\$36:\$F\$36,0)

``Please Login or Register  to view this content.``
Try to replace text value with their actual address

3. ## Re: Index and Match on multiple similar tables

Welcome to the forum.

INDEX MATCH MATCH with the AREA argument invoked will probably work for you.

There are instructions at the top of the page explaining how to attach your sample workbook.

4. ## Re: Index and Match on multiple similar tables

You have attached images that some members will not be able to see. I asked for a workbook - instructions at the top of the page.

5. ## Re: Index and Match on multiple similar tables

``Please Login or Register  to view this content.``
``Please Login or Register  to view this content.``
or
``Please Login or Register  to view this content.``

6. ## Re: Index and Match on multiple similar tables

Hey,

But what if I change the value Customer Type 30 to Customer Type 20. This won't work I guess.
I have attached the excel file.

Thanks again!!

7. ## Re: Index and Match on multiple similar tables

It works for me:

``Please Login or Register  to view this content.``

8. ## Re: Index and Match on multiple similar tables

Hello,

Assuming the columns (Rail, Truck, Plane & Ship) are in same order in each data group, Region can be in any order, if so use VLOOKUP like;

=VLOOKUP(J5,INDEX(B:B,MATCH(J9,B:B,0)):F28,MATCH(J7,B5:F5,0),0)

Change red highlighted to your last data row.

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