Help with Look Up with multiple complex conditions

[Excel Dumbo]

Hello Dear Excel Mates,

I have a table (attached) where i need to to auto populate Net Sale
values with multiple conditions. This is tearing my brain down. I hop
the excel mates in here can help me solve this.

much appreciate

+-------------------------------------------------------------------
|Filename: Complex Look UP.zip
|Download: http://www.excelbanter.com/attachment.php?attachmentid=467
+-------------------------------------------------------------------

 

[Don Guillett]

Hello Dear Excel Mates,

I have a table (attached) where i need to to auto populate Net Sales
values with multiple conditions. This is tearing my brain down. I hope
the excel mates in here can help me solve this.

much appreciated


+-------------------------------------------------------------------+
|Filename: Complex Look UP.zip |
|Download: http://www.excelbanter.com/attachment.php?attachmentid=467|
+-------------------------------------------------------------------+

Put identifiable month in row 1
1.2012 2.2012 3.2012
Jan Feb Mar

for e7>copy across
=SUMPRODUCT(--('LookUP Data'!$A$2:$A$300=E$1)*--(RIGHT('LookUP Data'!$E$2:$E$300,4)="tips")*'LookUP Data'!$I$2:$I$300)

For c4, etc copy across> & down

=SUMPRODUCT(--('LookUP Data'!$A$2:$A$29=E$1)*--('LookUP Data'!$E$2:$E$29=$C4),'LookUP Data'!$I$2:$I$29)

 

[Excel Dumbo]

Thank you very much Don

;1603626']On Thursday, July 12, 2012 7:43:27 PM UTC-5, Excel Dumb
wrote:-

Hello Dear Excel Mates,

I have a table (attached) where i need to to auto populate Net Sales
values with multiple conditions. This is tearing my brain down. hope
the excel mates in here can help me solve this.

much appreciated


+-------------------------------------------------------------------+
|Filename: Complex Look UP.zip |
|Download http://www.excelbanter.com/attachment.php?attachmentid=467|
+-------------------------------------------------------------------+

Put identifiable month in row 1
1.2012 2.2012 3.2012
Jan Feb Mar

for e7>copy across
=SUMPRODUCT(--('LookUP Data'!$A$2:$A$300=E$1)*--(RIGHT('LookU
Data'!$E$2:$E$300,4)="tips")*'LookUP Data'!$I$2:$I$300)

For c4, etc copy across> & down

=SUMPRODUCT(--('LookUP Data'!$A$2:$A$29=E$1)*--('LookU
Data'!$E$2:$E$29=$C4),'LookUP Data'!$I$2:$I$29

+-------------------------------------------------------------------
+-------------------------------------------------------------------