Hi marcelkahn,
See the attached file. It should be doing what you've asked for. I've had to make some minor changes to the file.
1)I've created a dynamic named range for locations called "List_Locations"
2) Created a another table in Locations sheet that picks up the appropriate Resin labels according to the selected locations using the formula:
3) Then, in the same manner as (1) above, I've created a named range for resins "List_Resins"
4) Finally, to pull up the relevant price, I've used the following INDEX MATCH function.
Bookmarks