Matching multiple columns and retrieving a value

[shzdug]

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.

 

[Biff]

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$10=D1),Source!E$1:E$10)

Biff