{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Question","Try","MrExcel","excelisfun","Sheet1","Sheet2"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":7,"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":"Question","index":0,"n_rows":20,"n_cols":8,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
["Carlos Simões from Portugal"]
[]
["\nI need to find a exact match, for a numerical"]
["value, within a matrix, and retrieve the cell"]
["reference for a index function. I have tried"]
["VLOOKUP, with MATCH and INDEX, but without"]
["sucess."]
["No Duplicates"]
["Goal: Create range from A13 to \"lookuped cell reference\"."]
[]
["Matrix:"]
[null,null,null,null,null,null,null,"Lookup Number"]
[4442,7226,1579,3682,1807,7178,null,61]
[6829,7658,6182,9432,6812,1638]
[2443,8974,7495,2790,2597,1673]
[8892,61,9543,883,7859,4471]
[7563,4541,6629,7196,4200,443]
[1303,7726,2484,9436,7543,5312]
[7884,6788,3532,7822,5637,3550]
[1899,2913,3306,5792,6012,1711]

{"sheet":"Try","index":1,"n_rows":20,"n_cols":8,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
["Carlos Simões from Portugal"]
[]
["\nI need to find a exact match, for a numerical"]
["value, within a matrix, and retrieve the cell"]
["reference for a index function. I have tried"]
["VLOOKUP, with MATCH and INDEX, but without"]
["success"]
["No Duplicates"]
["Goal: Create range from A13 to \"lookuped cell reference\"."]
[]
["Matrix:"]
[null,null,null,null,null,null,null,"Lookup Number"]
[4442,7226,1579,3682,1807,7178,null,61]
[6829,7658,6182,9432,6812,1638]
[2443,8974,7495,2790,2597,1673]
[8892,61,9543,883,7859,4471]
[7563,4541,6629,7196,4200,443]
[1303,7726,2484,9436,7543,5312]
[7884,6788,3532,7822,5637,3550]
[1899,2913,3306,5792,6012,1711]

{"sheet":"MrExcel","index":2,"n_rows":20,"n_cols":8,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
["Carlos Simões from Portugal"]
[]
["\nI need to find a exact match, for a numerical"]
["value, within a matrix, and retrieve the cell"]
["reference for a index function. I have tried"]
["VLOOKUP, with MATCH and INDEX, but without"]
["sucess."]
["No Duplicates"]
["Goal: Create range from A13 to \"lookuped cell reference\"."]
[]
["Matrix:"]
[null,null,null,null,null,null,null,"Lookup Number"]
[4442,7226,1579,3682,1807,7178,null,1711]
[6829,7658,6182,9432,6812,1638]
[2443,8974,7495,2790,2597,1673,null,{"$f":"whereis(H13,Matrix)","v":"$F$20"}]
[8892,61,9543,883,7859,4471]
[7563,4541,6629,7196,4200,443]
[1303,7726,2484,9436,7543,5312]
[7884,6788,3532,7822,5637,3550]
[1899,2913,3306,5792,6012,1711]

{"sheet":"excelisfun","index":3,"n_rows":27,"n_cols":8,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
["Carlos Simões from Portugal"]
[]
["\nI need to find a exact match, for a numerical"]
["value, within a matrix, and retrieve the cell"]
["reference for a index function. I have tried"]
["VLOOKUP, with MATCH and INDEX, but without"]
["sucess."]
["No Duplicates"]
["Goal: Create range from A13 to \"lookuped cell reference\"."]
[]
[]
["Matrix:"]
[4442,7226,1579,3682,1807,7178]
[6829,7658,6182,9432,6812,1638]
[2443,8974,7495,2790,2597,1673]
[8892,61,9543,883,7859,4471]
[7563,4541,6629,7196,4200,443]
[1303,7726,2484,9436,7543,5312]
[7884,6788,3532,7822,5637,3550]
[1899,2913,3306,5792,6012,1711]
[]
["Lookup Number","Row","Column","Relative Position Row","Relative Position Column"]
[6629,{"$f":"SUMPRODUCT((Matrix=A23)*ROW(Matrix))","v":17},{"$f":"SUMPRODUCT((Matrix=A23)*COLUMN(Matrix))","v":3},{"$f":"SUMPRODUCT((Matrix=A23)*(ROW(Matrix)-ROW(A13)+1))","v":5},{"$f":"SUMPRODUCT((Matrix=A23)*(COLUMN(Matrix)-COLUMN(A13)+1))","v":3}]
[]
["SUM Dynamic Range",{"$f":"SUM(INDIRECT(\"A13:\"&ADDRESS(SUMPRODUCT((Matrix=A23)*ROW(Matrix)),SUMPRODUCT((Matrix=A23)*COLUMN(Matrix)),4)))","v":90057}," <<== ADDRESS",null,null,null,null,"ADDRESS & INDIRECT, actual row & column numbers"]
["SUM Dynamic Range",{"$f":"SUM(A13:INDEX(Matrix,SUMPRODUCT((Matrix=A23)*(ROW(Matrix)-ROW(A13)+1)),SUMPRODUCT((Matrix=A23)*(COLUMN(Matrix)-COLUMN(A13)+1))))","v":90057},"<<== INDEX",null,null,null,null,"INDEX, actual relative postions in 2-way table"]
["SUM Dynamic Range",{"$f":"SUM(OFFSET(A13,,,SUMPRODUCT((Matrix=A23)*(ROW(Matrix)-ROW(A13)+1)),SUMPRODUCT((Matrix=A23)*(COLUMN(Matrix)-COLUMN(A13)+1))))","v":90057}," <<== OFFSET",null,null,null,null,"OFFSET can be used also. It is volatile, meaning it recalculates and can increase over formula calculation time for a workbook."]

{"sheet":"Sheet1","index":4,"n_rows":20,"n_cols":11,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
["Carlos Simões from Portugal"]
[]
["\nI need to find a exact match, for a numerical"]
["value, within a matrix, and retrieve the cell"]
["reference for a index function. I have tried"]
["VLOOKUP, with MATCH and INDEX, but without"]
["sucess. Can You help me with this problem?"]
["No Duplicates"]
["Goal: Create range from A13 to \"lookuped cell reference\"."]
[]
["Matrix:"]
[null,null,null,null,null,null,null,"Lookup Number",null,"ADDRESS function:","INDEX function:"]
[4442,7226,1579,3682,1807,7178,null,61,null,{"$f":"INDIRECT(\"A13:\"&ADDRESS(SUMPRODUCT((Matrix=H13)*ROW(Matrix)),SUMPRODUCT((Matrix=H13)*COLUMN(Matrix)),4))","v":4442},{"$f":"A13:INDEX(Matrix,SUMPRODUCT((Matrix=H13)*(ROW(Matrix)-MIN(ROW(Matrix))+1)),SUMPRODUCT((Matrix=H13)*(COLUMN(Matrix)-MIN(COLUMN(Matrix))+1)))","v":4442}]
[6829,7658,6182,9432,6812,1638]
[2443,8974,7495,2790,2597,1673]
[8892,61,9543,883,7859,4471]
[7563,4541,6629,7196,4200,443]
[1303,7726,2484,9436,7543,5312]
[7884,6788,3532,7822,5637,3550]
[1899,2913,3306,5792,6012,1711]

{"sheet":"Sheet2","index":5,"n_rows":20,"n_cols":8,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
["Carlos Simões from Portugal"]
[]
["\nI need to find a exact match, for a numerical"]
["value, within a matrix, and retrieve the cell"]
["reference for a index function. I have tried"]
["VLOOKUP, with MATCH and INDEX, but without"]
["sucess. Can You help me with this problem?"]
["No Duplicates"]
["Goal: Create range from A13 to \"lookuped cell reference\"."]
[]
["Matrix:"]
[null,null,null,null,null,null,null,"Lookup Number"]
[4442,7226,1579,3682,1807,7178,null,6629]
[6829,7658,6182,9432,6812,1638]
[2443,8974,7495,2790,2597,1673,null,"Address"]
[8892,61,9543,883,7859,4471,null,{"$f":"SUMPRODUCT(ROW(Matrix)*(Matrix=H13))","v":17}]
[7563,4541,6629,7196,4200,443,null,{"$f":"SUMPRODUCT(COLUMN(Matrix)*(Matrix=H13))","v":3}]
[1303,7726,2484,9436,7543,5312,null,{"$f":"SUM(INDIRECT(\"A13:\"&ADDRESS(SUMPRODUCT(ROW(Matrix)*(Matrix=H13)),SUMPRODUCT(COLUMN(Matrix)*(Matrix=H13)),4)))","v":90057}]
[7884,6788,3532,7822,5637,3550,null,{"$f":"SUM(A13:INDEX(Matrix,SUMPRODUCT((ROW(Matrix)-MIN(ROW(Matrix))+1)*(Matrix=H13)),SUMPRODUCT((COLUMN(Matrix)-MIN(COLUMN(Matrix))+1)*(Matrix=H13))))","v":90057}]
[1899,2913,3306,5792,6012,1711]