{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Index Match","CheckinTable","ValueRanges"],"not_rendered":{"charts":1,"images":0,"macros":0,"external_links":1,"defined_names":24,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Index Match","index":0,"n_rows":19,"n_cols":6,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[]
["PROBLEM"]
[null,null,null,"Joining Month"]
["Zubair","Pakistan","Male","????"]
[]
[]
["Names","Country","Sex","Joining Month"]
["Junaid","Pakistan","Male","Jan"]
["Noman","Saudi","Male","Feb"]
["Zubair","Irani","Male","Mar"]
["Zubair","Pakistan","Male","Apr"]
["Zubair","Saudi","Male","May"]
[]
["SOLUTION"]
[null,null,null,"First Way","Alternate Way","Thirdway"]
[]
["Zubair","Pakistan","Male",{"$f":"INDEX(D8:D12,MATCH(A4&B4&C4,A8:A12&B8:B12&C8:C12,0))","v":"Apr"},{"$f":"INDEX(A8:D12,MATCH(1,(A4=A8:A12)*(B4=B8:B12)*(C4=C8:C12),0),4)","v":"Apr"},{"$f":"SUMIFS(D8:D12,A8:A12,A4,B8:B12,B4,C8:C12,C4)","v":0}]
[null,null,null,null,null,"You can use SumIfs to lookup Values with Multiple Conditions. However it doesn't work with Text Lookups."]
[null,null,null,null,null,"Because you cannot Sum TEXT"]

{"sheet":"CheckinTable","index":1,"n_rows":26,"n_cols":28,"rows_kept":26,"cut":false,"hidden":false,"merged":[[1,0,1,2]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,2,3,4,5]
["Expense Items",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,"Jan","Feb ","Mar","Apr","May"]
["Cost of Sales","Salaries","Raw Materials used",null,"INCOME STATEMENT","Jan","Feb ","Mar","Apr","May",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(E4:E26,W2)","v":"Salaries"},{"$f":"INDEX($F$4:$J$26,$W$2,U1)","v":-20},{"$f":"INDEX($F$4:$J$26,$W$2,V1)","v":-17},{"$f":"INDEX($F$4:$J$26,$W$2,W1)","v":-14},{"$f":"INDEX($F$4:$J$26,$W$2,X1)","v":-14},{"$f":"INDEX($F$4:$J$26,$W$2,Y1)","v":-14}]
["Admin Expenses","Bonus","Fuel and Power",null,"Revenue",13,10,20,16,20,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Adjusted \"&W3","v":"Adjusted Salaries"},{"$f":"X3*$C$17","v":20},{"$f":"Y3*$C$17","v":17},14,14,14]
["Marketing Cost","Advertising","Utilities",null,"Cost of Sales",-15,-13,-13,-16,-20]
["Operating expenses","Rent of Property","Printing & Stationery",null,"Gross Profit",19,12,17,11,20]
["Tax","Finance Cost","License Fees",null,"Admin Expenses",-10,-10,-12,-15,-13]
["Depreciation","Repairs & maintenance","Consultancy",null,"Marketing Cost",-17,-18,-19,-10,-13]
[null,null,null,null,"Operating expenses",-10,-16,-11,-17,-16]
[null,null,null,null,"Depreciation",-18,-17,-12,-15,-11]
[null,null,null,null,"Tax",-20,-11,-17,-10,-12]
[null,null,null,null,"Other Income",15,13,-6,12,-1]
[null,null,null,null,"Salaries",-20,-17,-14,-14,-14]
[null,null,null,null,"Bonus",-19,-11,-13,-20,-18]
[null,null,null,null,"Advertising",-12,-20,-13,-13,-18]
["LOOK UP ITEM","RESULT","Multiplier",null,"Rent of Property",-16,-20,-18,-17,-12]
[{"$f":"W3","v":"Salaries"},{"$f":"IF(OR(A17=Expenses),\"Expense Item\",\"Income Item\")","v":"Expense Item"},{"$f":"IF(B17=\"Expense Item\",-1,1)","v":-1},null,"Finance Cost",-17,-17,-14,1,-11]
[null,null,null,null,"Scrap Sales",15,18,20,17,19]
[null,null,null,null,"Repairs & maintenance",-12,-17,-13,-20,-11]
[null,null,null,null,"Raw Materials used",-10,-20,-16,-14,-12]
[null,null,null,null,"Fuel and Power",-13,-20,-14,-14,-13]
[null,null,null,null,"Utilities",-14,-16,-14,-10,-12]
[null,null,null,null,"Printing & Stationery",-18,-10,-20,-17,-10]
[null,null,null,null,"License Fees",-16,-10,-18,-12,-20]
[null,null,null,null,"Consultancy",-10,-11,-16,-10,-11]
[null,null,null,null,"Net Income",19,13,10,-17,17]

{"sheet":"ValueRanges","index":2,"n_rows":16,"n_cols":18,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,8,1,10]]}
[]
["Name","Number","Grade",null,null,null,null,null,"---------------------Parameters---------------"]
["Zubair ",6454,{"$f":"INDEX($K$4:$K$10,MATCH(1,(B3>=$I$4:$I$10)*(B3<=$J$4:$J$10),0))","v":"A"},null,null,null,null,null,"Min Salary","Max Salary","Grade"]
["Ismael",56562,{"$f":"INDEX($K$4:$K$10,MATCH(1,(B4>=$I$4:$I$10)*(B4<=$J$4:$J$10),0))","v":"E"},{"$f":"INDEX($K$4:$K$29,MATCH(B3,$I$4:$I$29,1),1)","v":"A"},{"$f":"MATCH(1,(B3>=$I$4:$I$9)*(B3<=$J$4:$J$9),0)","v":1},{"$f":"INDEX(K4:K9,E4)","v":"A"},null,null,0,20000,"A"]
["Junaid",9980,{"$f":"INDEX($K$4:$K$10,MATCH(1,(B5>=$I$4:$I$10)*(B5<=$J$4:$J$10),0))","v":"A"},"E",{"$f":"MATCH(1,(B4>=$I$4:$I$9)*(B4<=$J$4:$J$9),0)","v":5},null,null,null,20001,30000,"B"]
["Kashif",42402,{"$f":"INDEX($K$4:$K$10,MATCH(1,(B6>=$I$4:$I$10)*(B6<=$J$4:$J$10),0))","v":"D"},"A",{"$f":"MATCH(1,(B5>=$I$4:$I$9)*(B5<=$J$4:$J$9),0)","v":1},null,null,null,30001,40000,"C"]
["Hasan",64197,{"$f":"INDEX($K$4:$K$10,MATCH(1,(B7>=$I$4:$I$10)*(B7<=$J$4:$J$10),0))","v":"F"},"D",{"$f":"MATCH(1,(B6>=$I$4:$I$9)*(B6<=$J$4:$J$9),0)","v":4},null,null,null,40001,50000,"D"]
["Tamer",47394,{"$f":"INDEX($K$4:$K$10,MATCH(1,(B8>=$I$4:$I$10)*(B8<=$J$4:$J$10),0))","v":"D"},"F",{"$f":"MATCH(1,(B7>=$I$4:$I$9)*(B7<=$J$4:$J$9),0)","v":6},null,null,null,50001,60000,"E"]
[null,null,null,"D",{"$f":"MATCH(1,(B8>=$I$4:$I$9)*(B8<=$J$4:$J$9),0)","v":4},null,null,null,60001,70000,"F"]
[null,null,null,null,null,null,null,null,70001,80000,"G"]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRUE+1","v":2},{"$f":"Q16+1","v":3}]