Sorry for the delay.
Here,I have attached the file with macro.When u click the breakup button it gives the result X9 below and across.The sum.of total must match with X8 and across with that of below of each column from X9 .The decimal part is not done.Another tab for clearing the data from X9...
Hi,
I want to do little modification in below code for which I would like to figure out column name.Secondly,I want the modification regarding numbers which is not taking here when the numbers are in decimal like 250.45 i.e it is not subtracting the number after decimal.Hence,taking whole...
Dramatic layout would sure exist.This is so becoz,if u see properly,data month 1 is mentioned in both A:D and H:K.But what happens when,I alter month from 1 to 2 in A4. Naturally,data should move from N to P column.
Secondly,columns I:J grey cells are useless
This is not useless,why ? becoz...
Initially,I thought it would be possible or not.After your #Post,I tested and worked well and was eager to go one step further towards my ultimate goal.:).
I hope you can help me.
There are no words how to thank u Marc L.
I want to go to one step further.
I have added 1 more name 'Y'.I have added the manually the result by highlighting in N column.Process is the same as you have done for 'X'.
One most important thing,
1.Matching of column C and I
2.I have added month...
X is the name that must match with J column.Here,in above post,I have attached file where,I have mentioned the same name 'X'.This would be a matching criteria.
Hi,Thanx for the reply.
In this case,answer is correct but when I change the value in D4 it gives me wrong answer.
Plz check the file in sheets called Scenario 2 and 3.The correct answer I have mentioned manually in O column.
I have also mentioned the logic in M column.It will simply take each...
Ok.
F3
=IFERROR(INDEX('Lookup Data'!$B$4:$B$9,IFERROR(MATCH(B3,'Lookup Data'!$C$4:$C$7,),MATCH(B3,'Lookup Data'!$H$4:$H$9,))),"")
G3
=IF(F3="","",SUMIFS('Lookup Data'!$F$4:$K$9,'Lookup Data'!$C$4:$H$9,B3))
If anyone have different formula getting same results I would appreciate further.
Link
Kindly help me in getting alternative formula for 2013 or lower version till 2007.
FILTER(CHOOSE({1,2},'Lookup Data'!$B$4:$B$7,'Lookup Data'!$F$4:$F$7),B3='Lookup Data'!$C$4:$C$7,
FILTER(CHOOSE({1,2},'Lookup Data'!$B$4:$B$7,'Lookup Data'!$K$4:$K$7),B3='Lookup Data'!$H$4:$H$7,""))
I want simply to match column with another worksheet and get the multiple columns specified.I don't like to match row header.I have mentioned header just to ease the query.
Ok.There is another that tried but something is wrong.=LET(z,LAX!C6:R972,l,A3:A1752,FILTER(FILTER(SORTBY(z,MATCH(INDEX(z,,16),l,)),SEQUENCE(ROWS(z))<=ROWS(l)),{0,0,1,0,0,0,0,0,1,0,0,0,0,0,1,1}))
I want to get data by range lookup and return in array.
Something like below.
Xlookup (A5:A979,Data!C7:C1120,Data!A7:A1120+Data!B7:B1120+Data!D7:D1120+Data!L7:L1120+Data!N7:O1120)