vblookup with 2 field of criteria

[jamiguel77]

hi, how do this:

A1=Jhon Smith
B1=Orange
C1=500

A2=Peter Award
B2=Bannana
C2=200

A3=Jhon Smith
B3=Lemon
C3=210


if i want do a Vblookup formula for find: Jhon Smith and Lemon ?

Thanks

 

[arthurbr]

One way

=sumproduct(--(a1:a3="Jhon Smith"),--(b1:b3="Lemon")*c1:c3)

 

[jamiguel77]

Excellent, tested and worked....

Thanks

 

[arthurbr]

You're welcome