i trying to complete my excel worksheet

February 27, 2012 at 14:17:38
Specs: Windows 7
i need a formula for my excel workbook

See More: i trying to complete my excel worksheet

Report •


#1
February 27, 2012 at 19:44:32
Here, use this one:

=IF(IF(INDEX(temp.xls!A:F,SUM(MATCH("EENU",temp.xls!A:A,0),MATCH("BF304",
OFFSET(temp.xls!A1,MATCH("EENU",temp.xls!A:A,0)-1,0,MATCH("FCLI",temp.xls!A:A,
0)-MATCH("EENU",temp.xls!A:A,0)+1,1),0))-1,5)<>0,5,6)=5,INDEX(temp.xls!A:F,
SUM(MATCH("EENU",temp.xls!A:A,0),MATCH("BF304",OFFSET(temp.xls!A1,
EQUIV("EENU",temp.xls!A:A,0)-1,0,MATCH("FCLI",temp.xls!A:A,0)-MATCH("EENU",
temp.xls!A:A,0)+1,1),0))-1,IF(INDEX(temp.xls!A:F,SUM(MATCH("EENU",temp.xls!A:A,
0),MATCH("BF304",OFFSET(temp.xls!A1,MATCH("EENU",temp.xls!A:A,0)-1,0,
MATCH("FCLI",temp.xls!A:A,0)-MATCH("EENU",temp.xls!A:A,0)+1,1),0))-1,5<>0,
5,6)),-INDEX(temp.xls!A:F,SUM(MATCH("EENU",temp.xls!A:A,0),MATCH("BF304",
OFFSET(temp.xls!A1,MATCH("EENU",temp.xls!A:A,0)-1,0,MATCH("FCLI",temp.xls!A:A,
0)-MATCH("EENU",temp.xls!A:A,0)+1,1),0))-1,IF(INDEX(temp.xls!A:F,
SUM(MATCH("EENU",temp.xls!A:A,0),MATCH("BF304",OFFSET(temp.xls!A1,
MATCH("EENU",temp.xls!A:A,0)-1,0,MATCH("FCLI",temp.xls!A:A,0)-MATCH("EENU",
temp.xls!A:A,0)+1,1),0))-1,5)<>0,5,6)))

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •
Related Solutions


Ask Question