vlookup in two condition

[val via OfficeKB.com]

Hi,

I have problem with using vlookup function fo the following case
A B C
1 from to amount
2 jkt cape 1
3 jkt bdg 2
4 smg bdg 3
5 smg bdg 7

What is the formula if I want tolook up from jkt to bdg the result would be
2.

Thanks

 

[Arvi Laanemets]

Hi

=SUMPRODUCT(--($A$1:$A$1000="jkt"),--($B$1:$B$1000="bgd"),$C$1:$A$1000)