Hi there,

I've got following constellation:
A1 to C4 is a little database
in A6, I put in a name like CAIRO
in A7, I put in a description like CA M 4


Whenever CA is part of the description, the formula must give me C817
as result in cell A9. My problem is, that 'CA' is only a part of the
description.


A B C
1 CAIRO PB M 6 C816
2 CAIRO CA M 4 C817
3 CAIRO PB M 3 C816
4 CAIRO CA M 2 C817
5
6 CAIRO
7 CA M 4
8
9 =SUMPRODUCT(((A1:A3=A6)*(B1:B3=A7))*C1:C3)

Can anyone help me please?

Thanks a lot

Norbert