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

--
Message posted via http://www.officekb.com

Hi

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

--
When sending mail, use address arvil<attarkon.ee
Arvi Laanemets



"val via OfficeKB.com" wrote in message
...
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

--
Message posted via http://www.officekb.com