Vlookup off multiple columns
On Wed, 22 Jul 2009 05:10:01 -0700, James
wrote:
Hello there
I am trying to do a vlookup off multiple columns. For example below if I am
trying to find the result of "22" for a value "ZZ" in columns A to C below
how to I tell it to lookup in all 3 columns i.e. A-C and return the result in
column D?
A B C D
ZX ZZ ZA 22
Try this formula:
=SUMPRODUCT(--((A1:A100="ZZ")+(B1:B100="ZZ")+(C1:C100="ZZ")0)*( D1:D100))
Change 100 in all places to fit the number od rows with data you have.
This formula will return the sum in column D for all rows where there
is a "ZZ" in either of the columns A to C.
Hope this helps/ Lars-Åke
|