Forum Discussion
look up text in a cell, given criteria from 2 columns and one row in a source table
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, so...
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.