look up text in a cell, given criteria from 2 columns and one row in a source table

[Glenn Mysko]

Hello I have a table of data that has 2 first column being the criteria in conjunction with one row of headers along the top

ie     col 1 "drums; totes; bulk"

       col 2 " east, west, north, south"

      top row headers " Al, Fe, Cu, Zn"

drop down list to pick col 1 (packaging), col 2 (gate location), row 1(metal type).

I'm thinking Vlookup all three criteria in the source table should pull out text from intersecting cell

I need help with syntax and best technique please

thank you in advance

[#2]

Please provide a sample file with non-sensitive data in order to better address your specific question.  Based on the scenario you describe  I believe you actually want a SumProduct formula.  Here are a few examples:

https://chandoo.org/wp/2010/11/09/2way-lookup-formulas/

https://www.ablebits.com/office-addins-blog/2016/08/24/excel-sumproduct-function-formula-examples/

In addition I have attached a file for reference.