{"text_format":"3","workbook":"xlsx","n_sheets":5,"sheets":["INDEX-MATCH","PivotTable","VLOOKUP","INDEX-SMALL","Sheet1"],"not_rendered":{"images":1,"defined_names":1,"pivot_tables":1},"read":"whole","date_system":"1900"}

{"sheet":"INDEX-MATCH","index":0,"n_rows":11,"n_cols":7,"rows_kept":11}
["Employee ","Department","Sales","Target",null,"Employee List","Sales"]
["Alice","North",{"v":12500,"d":"$12,500.00"},{"v":15000,"d":"$15,000.00"},null,"Alice",{"$f":"INDEX($C$2:$C$11, MATCH(F2, $A$2:$A$11, 0))","v":{"v":12500,"d":"$12,500.00"}}]
["Bob","South",{"v":3800,"d":"$3,800.00"},{"v":4500,"d":"$4,500.00"},null,"Frank",{"v":2300,"d":"$2,300.00"}]
["Carol","East",{"v":14200,"d":"$14,200.00"},{"v":13000,"d":"$13,000.00"},null,"Bob",{"v":3800,"d":"$3,800.00"}]
["David","North",{"v":2950,"d":"$2,950.00"},{"v":3500,"d":"$3,500.00"},null,"Ivy",{"v":6700,"d":"$6,700.00"}]
["Eva","South",{"v":7600,"d":"$7,600.00"},{"v":8000,"d":"$8,000.00"}]
["Frank","East",{"v":2300,"d":"$2,300.00"},{"v":2500,"d":"$2,500.00"}]
["Grace","North",{"v":9800,"d":"$9,800.00"},{"v":11000,"d":"$11,000.00"}]
["Henry","South",{"v":4100,"d":"$4,100.00"},{"v":4500,"d":"$4,500.00"}]
["Ivy","East",{"v":6700,"d":"$6,700.00"},{"v":7000,"d":"$7,000.00"}]
["Jack","North",{"v":3200,"d":"$3,200.00"},{"v":3500,"d":"$3,500.00"}]

{"sheet":"PivotTable","index":1,"n_rows":14,"n_cols":9,"rows_kept":14}
[null,"Column Labels"]
[null,"East",null,"North",null,"South",null,"Total Sum of Sales","Total Sum of Target"]
["Row Labels","Sum of Sales","Sum of Target","Sum of Sales","Sum of Target","Sum of Sales","Sum of Target"]
["Alice",null,null,{"v":12500,"d":"$12,500.00"},{"v":15000,"d":"$15,000.00"},null,null,{"v":12500,"d":"$12,500.00"},{"v":15000,"d":"$15,000.00"}]
["Bob",{"$nulls":4},{"v":3800,"d":"$3,800.00"},{"v":4500,"d":"$4,500.00"},{"v":3800,"d":"$3,800.00"},{"v":4500,"d":"$4,500.00"}]
["Carol",{"v":14200,"d":"$14,200.00"},{"v":13000,"d":"$13,000.00"},{"$nulls":4},{"v":14200,"d":"$14,200.00"},{"v":13000,"d":"$13,000.00"}]
["David",null,null,{"v":2950,"d":"$2,950.00"},{"v":3500,"d":"$3,500.00"},null,null,{"v":2950,"d":"$2,950.00"},{"v":3500,"d":"$3,500.00"}]
["Eva",{"$nulls":4},{"v":7600,"d":"$7,600.00"},{"v":8000,"d":"$8,000.00"},{"v":7600,"d":"$7,600.00"},{"v":8000,"d":"$8,000.00"}]
["Frank",{"v":2300,"d":"$2,300.00"},{"v":2500,"d":"$2,500.00"},{"$nulls":4},{"v":2300,"d":"$2,300.00"},{"v":2500,"d":"$2,500.00"}]
["Grace",null,null,{"v":9800,"d":"$9,800.00"},{"v":11000,"d":"$11,000.00"},null,null,{"v":9800,"d":"$9,800.00"},{"v":11000,"d":"$11,000.00"}]
["Henry",{"$nulls":4},{"v":4100,"d":"$4,100.00"},{"v":4500,"d":"$4,500.00"},{"v":4100,"d":"$4,100.00"},{"v":4500,"d":"$4,500.00"}]
["Ivy",{"v":6700,"d":"$6,700.00"},{"v":7000,"d":"$7,000.00"},{"$nulls":4},{"v":6700,"d":"$6,700.00"},{"v":7000,"d":"$7,000.00"}]
["Jack",null,null,{"v":3200,"d":"$3,200.00"},{"v":3500,"d":"$3,500.00"},null,null,{"v":3200,"d":"$3,200.00"},{"v":3500,"d":"$3,500.00"}]
["Grand Total",{"v":23200,"d":"$23,200.00"},{"v":22500,"d":"$22,500.00"},{"v":28450,"d":"$28,450.00"},{"v":33000,"d":"$33,000.00"},{"v":15500,"d":"$15,500.00"},{"v":17000,"d":"$17,000.00"},{"v":67150,"d":"$67,150.00"},{"v":72500,"d":"$72,500.00"}]

{"sheet":"VLOOKUP","index":2,"n_rows":11,"n_cols":8,"rows_kept":11}
["Employee ","Department","Sales","Target",null,"Employee List","Sales","Target"]
["Alice","North",{"v":12500,"d":"$12,500.00"},{"v":15000,"d":"$15,000.00"},null,"Alice",{"$f":"IFERROR(VLOOKUP(F2, $A$2:$D$11, 3, FALSE), \"\")","v":{"v":12500,"d":"$12,500.00"}},{"$f":"IFERROR(VLOOKUP(F2, $A$2:$D$11, 4, FALSE), \"\")","v":{"v":15000,"d":"$15,000.00"}}]
["Bob","South",{"v":3800,"d":"$3,800.00"},{"v":4500,"d":"$4,500.00"},null,"Frank",{"$f":"IFERROR(VLOOKUP(F3, $A$2:$D$11, 3, FALSE), \"\")","v":{"v":2300,"d":"$2,300.00"}},{"$f":"IFERROR(VLOOKUP(F3, $A$2:$D$11, 4, FALSE), \"\")","v":{"v":2500,"d":"$2,500.00"}}]
["Carol","East",{"v":14200,"d":"$14,200.00"},{"v":13000,"d":"$13,000.00"},null,"Bob",{"$f":"IFERROR(VLOOKUP(F4, $A$2:$D$11, 3, FALSE), \"\")","v":{"v":3800,"d":"$3,800.00"}},{"$f":"IFERROR(VLOOKUP(F4, $A$2:$D$11, 4, FALSE), \"\")","v":{"v":4500,"d":"$4,500.00"}}]
["David","North",{"v":2950,"d":"$2,950.00"},{"v":3500,"d":"$3,500.00"},null,"Ivy",{"$f":"IFERROR(VLOOKUP(F5, $A$2:$D$11, 3, FALSE), \"\")","v":{"v":6700,"d":"$6,700.00"}},{"$f":"IFERROR(VLOOKUP(F5, $A$2:$D$11, 4, FALSE), \"\")","v":{"v":7000,"d":"$7,000.00"}}]
["Eva","South",{"v":7600,"d":"$7,600.00"},{"v":8000,"d":"$8,000.00"}]
["Frank","East",{"v":2300,"d":"$2,300.00"},{"v":2500,"d":"$2,500.00"}]
["Grace","North",{"v":9800,"d":"$9,800.00"},{"v":11000,"d":"$11,000.00"}]
["Henry","South",{"v":4100,"d":"$4,100.00"},{"v":4500,"d":"$4,500.00"}]
["Ivy","East",{"v":6700,"d":"$6,700.00"},{"v":7000,"d":"$7,000.00"}]
["Jack","North",{"v":3200,"d":"$3,200.00"},{"v":3500,"d":"$3,500.00"}]

{"sheet":"INDEX-SMALL","index":3,"n_rows":11,"n_cols":7,"rows_kept":11}
["Employee ","Department","Sales","Target",null,"Employee (North)","Employee (South)"]
["Alice","North",{"v":12500,"d":"$12,500.00"},{"v":15000,"d":"$15,000.00"},null,{"$f":"IFERROR(INDEX($A$2:$A$11, SMALL(IF($B$2:$B$11=\"North\", ROW($B$2:$B$11)-1, FALSE), ROW()-1)), \"\")","v":"Alice"},{"$f":"IFERROR(INDEX($A$2:$A$11, SMALL(IF($B$2:$B$11=\"South\", ROW($B$2:$B$11)-1, FALSE), ROW()-1)), \"\")","v":"Bob"}]
["Bob","South",{"v":3800,"d":"$3,800.00"},{"v":4500,"d":"$4,500.00"},null,{"$f":"IFERROR(INDEX($A$2:$A$11, SMALL(IF($B$2:$B$11=\"North\", ROW($B$2:$B$11)-1, FALSE), ROW()-1)), \"\")","v":"David"},{"$f":"IFERROR(INDEX($A$2:$A$11, SMALL(IF($B$2:$B$11=\"South\", ROW($B$2:$B$11)-1, FALSE), ROW()-1)), \"\")","v":"Eva"}]
["Carol","East",{"v":14200,"d":"$14,200.00"},{"v":13000,"d":"$13,000.00"},null,{"$f":"IFERROR(INDEX($A$2:$A$11, SMALL(IF($B$2:$B$11=\"North\", ROW($B$2:$B$11)-1, FALSE), ROW()-1)), \"\")","v":"Grace"},{"$f":"IFERROR(INDEX($A$2:$A$11, SMALL(IF($B$2:$B$11=\"South\", ROW($B$2:$B$11)-1, FALSE), ROW()-1)), \"\")","v":"Henry"}]
["David","North",{"v":2950,"d":"$2,950.00"},{"v":3500,"d":"$3,500.00"},null,{"$f":"IFERROR(INDEX($A$2:$A$11, SMALL(IF($B$2:$B$11=\"North\", ROW($B$2:$B$11)-1, FALSE), ROW()-1)), \"\")","v":"Jack"},{"$f":"IFERROR(INDEX($A$2:$A$11, SMALL(IF($B$2:$B$11=\"South\", ROW($B$2:$B$11)-1, FALSE), ROW()-1)), \"\")","v":""}]
["Eva","South",{"v":7600,"d":"$7,600.00"},{"v":8000,"d":"$8,000.00"}]
["Frank","East",{"v":2300,"d":"$2,300.00"},{"v":2500,"d":"$2,500.00"}]
["Grace","North",{"v":9800,"d":"$9,800.00"},{"v":11000,"d":"$11,000.00"}]
["Henry","South",{"v":4100,"d":"$4,100.00"},{"v":4500,"d":"$4,500.00"}]
["Ivy","East",{"v":6700,"d":"$6,700.00"},{"v":7000,"d":"$7,000.00"}]
["Jack","North",{"v":3200,"d":"$3,200.00"},{"v":3500,"d":"$3,500.00"}]

{"sheet":"Sheet1","index":4,"n_rows":11,"n_cols":3,"rows_kept":11}
["Employee ","Department","Sales"]
["Alice","North",12500]
["Bob","South",3800]
["Carol","East",14200]
["David","North",2950]
["Eva","South",7600]
["Frank","East",2300]
["Grace","North",9800]
["Henry","South",4100]
["Ivy","East",6700]
["Jack","North",3200]