excel index match
Posted on 2011-05-03
Hopefully someone can just see the syntax i have and tell me where the mistake is. If not I will load a sample spreadsheet later. The following is the formula is not working.
=INDEX('SAP Price'!$D$2:$D$3474,MATCH(1,INDEX(('SAP Price'!$B$2:$B$5000='03-2011'!D19)*('SAP Price'!$C$2:$C$5000='03-2011'!F19)*('SAP Price'!$E$2:$E$5000<='03-2011'!C19)*('SAP Price'!$F$2:$F$5000>'03-2011'!C19),0),0))