vlookup in two condition
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 |
All times are GMT +1. The time now is 01:18 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com