Here are three ways to lookup a value based on two columns. Let’s start with this random data: And let’s say that we want to lookup the autonumber value for Carlo. Not the Carlo in Seaford, but the Carlo in Westwood.
SUMPRODUCT
With ‘Carlo’ in E2 and ‘Westwood’ in F2, use =SUMPRODUCT(($A$2:$A$16=E2)*($B$2:$B$16=F2)*(C2:C16))
If you have more [...]
Read More...
Read the complete post at http://www.dailydoseofexcel.com/archives/2009/04/21/vlookup-on-two-columns/
Posted
Apr 21 2009, 04:19 PM
by
Daily Dose of Excel