lookup multiple columns

[Guest]

I want to lookup the following:

A B C D E
Customer Period Customer Period Sales
500 1 500 3 100
500 2 501 1 50
500 3 510 2 100
501 1
501 2
501 3

I want to show column A and B for all customers, each customer will have
periods 1-3, i want to reference column C and D and where C,D match A,B place
the sales field.

When it is done I want it to look like this:

A B C
Customer Period Sales
500 1 0
500 2 0
500 3 100

Please help.

 

[duane]

I had to add a column F = where f5 = d5&e5

=IF(ISNA(MATCH(A18&B18,$F$5:$F$10,0)),0,OFFSET($E$4,MATCH(A18&B18,$F$5:$F$10,0),0,1,1))

where the data with columns a-e (now f) are in rows 5-10, any m
summary tanle (columns a-c) start in row 18. This finds a match o
column c&d in the orginal table with columns a&b in the summary tabl
and puts in the sales # from column e of the original table, or zero i
there is no match