Matrix data lookup

[m4l490n]

I want to select a value from the cost matrix that you can see in the file "Cost Matrix.xlsx".

The way I need to do this is using the drop down menus that you can see below the matrix. In the drop down menus "Qty" and "Time" you can select any option from 10 to 200 for Qty and from Same Day to 4-week for Time.

Basically what I want to do is place a formula or something in the red-outlined cell (Cost) that shows the corresponding price based on both selections from Qty and Time.

Thanks

[DonkeyOte]

One possibility would be to use an INDEX with 2 MATCH calls (row, column)

Please Login or Register  to view this content.

[m4l490n]

One possibility would be to use an INDEX with 2 MATCH calls (row, column)

Please Login or Register  to view this content.

Thanks!! that's it!