look up

[pgarcia]

Hello all,
I'm needing to do the following: if(and(a1=b2,c2=d2),e2,"")
but, I need to look through colums. Like Vlookup.
if(and(a1=b:b,c2=d:d),e:e,"")

Thanks

 

[Don Guillett]

I think you are looking for this. Don't use the whole column unless xl2007

=sumproduct((b2:b22=a1)*(d2:d22=c2)*e2:e22)
or
=sumproduct(--(b2:b22=a1),--(d2:d22=c2),e2:e22)

 

[pgarcia]

Thanks, but I just remmber I had this in another workbook
=INDEX('101408'!$B$2:$R$21,MATCH(M2,'101408'!$A$2:$A$24,0),MATCH(I2,'101408'!$B$1:$R$1,0))

And that worked. Thanks