Match multiple columns in multiple lists

[sbolt6]

Hello


I am trying to match two columns in one list with two columns in a second list. What is the formula to verify this? For example, list 1 has column A(address), column B(bin size) and list 2 has column D(address) and column E(bin size). In list 1, the address could have multiple bin sizes so I only want to retrieve the rows in that list that have an exact match of address AND bin size in list 2.


Thanks in advance!!

 

[Hui]

I'd have a look at using Index Match

for a description have a look here

http://chandoo.org/wp/2010/11/02/multi-condition-lookup/

It also describes a few alternatives

 

[sbolt6]

Thanks again Hui! For everyone else, the sumproduct function did the trick. I appreciate you time and efforts.