look up
 

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

look up
 

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)

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"pgarcia" wrote in message
...
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

look up
 

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

"Don Guillett" wrote:


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)

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"pgarcia" wrote in message
...
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