# INDEX MATCH with 2 criteria

1. ## INDEX MATCH with 2 criteria

Hello friends,

I have a problem. I will extremely appreciate if someone call help me.

I need to fill shipping charge taking into consideration 1) zone 2) weight 3) carrier

I believe it can be done with INDEX and MATCH but here we need to have 3 criteria. Does anyone know how to do it?

3.JPG

4.JPG

2. ## Re: INDEX MATCH with 2 criteria

You could make your life easier if you forego the "pretty" layout and put all the tables in line. Then you can do a MATCH against the Courier. You can then use that as an Offset added to a MATCH on the Zone. And the Row MATCH would be a simple one on the Weight.

3. ## Re: INDEX MATCH with 2 criteria

TMS thank you for your reply. I am not sure what exactly you suggest to do. Could you please (if you can) do it with one table so that i see visually want i need to do. I appreciate your kindness and help.

4. ## Re: INDEX MATCH with 2 criteria

INDEX has a little known 4th argument for "Area" Each of your tables would be a different area. This works if all of your tables are set up the same, which they are.
Holding down the CNTRL Key, select the data portion of each of your tables. Then, in the "Name box" (that white rectangle where you usually see the cell ID) type in what you want to call your data (I called it MyData) and press ENTER. You can now use this formula in G2 copied down
Formula:
`Please Login or Register  to view this content.`

I also added the formula for fuel charge in H2
Formula:
`Please Login or Register  to view this content.`

See attachment

5. ## Re: INDEX MATCH with 2 criteria

ChemistB

I have 1 more question. Do you know how I can calculate the average shipping cost per carrier? Is there some kind of function that can contain both IF and AVG. So that it can look at column C and depending on the carrier average the shipping cost.

If you know how, please let me know. I really appreciate your kindness and help.

6. ## Re: INDEX MATCH with 2 criteria

Does anyone know how to calculate shipping cost per carrier. Looking at column C and averaging shipping charge for a specific carrier.

4q.JPG

7. ## Re: INDEX MATCH with 2 criteria

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

#### 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