Matching multiple columns and retrieving a value
 

I'm trying to match multple colums in two sheets, then pull a rate from one
sheet into another.

My source sheet looks like this:

A B C D E
Line Class Product Descr Rate
---- ----- --------- ----- -----
Term Report ATM LL .08
Term Report ATM DU .15

My second sheet will have the following:

A B C D E
Line Class Product Descr Rate
---- ----- --------- ----- -----
Term Report ATM LL
Term Report ATM DU

I need to pull the rate from sheet 1 into sheet 2. I have approx. 1,000
different combinations to sort through. Any help would be appreciated.

Matching multiple columns and retrieving a value
 

Hi!

This will work as long as there are no duplicates:

=SUMPRODUCT(--(Source!A$1:A$10=A1),--(Source!B$1:B$10=B1),--(Source!C$1:C$10=C1),--(Source!D$1:D$10=D1),Source!E$1:E$10)

Biff

"shzdug" wrote in message
...
I'm trying to match multple colums in two sheets, then pull a rate from
one
sheet into another.

My source sheet looks like this:

A B C D E
Line Class Product Descr Rate
---- ----- --------- ----- -----
Term Report ATM LL .08
Term Report ATM DU .15

My second sheet will have the following:

A B C D E
Line Class Product Descr Rate
---- ----- --------- ----- -----
Term Report ATM LL
Term Report ATM DU

I need to pull the rate from sheet 1 into sheet 2. I have approx. 1,000
different combinations to sort through. Any help would be appreciated.