{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Cell Reference","VBA-Range of Cells","VBA-Single Cell","INDEX-MATCH","Value-concatenate","Vlookup","Hlookup","Bonus Sheet"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"Cell Reference","index":0,"n_rows":9,"n_cols":7,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["Excel Formula to Copy Cell value to Another Cell"]
[]
["First Name","Last Name","Age",null,"Copy First Name","Copy Last Name","Copy Age"]
["John ","Adams",21,null,{"$f":"A4","v":"John "},{"$f":"B4","v":"Adams"},{"$f":"C4","v":21}]
["Ryan ","Giggs",35,null,{"$f":"A5","v":"Ryan "},{"$f":"B5","v":"Giggs"},{"$f":"C5","v":35}]
["Matt","Henry",31,null,"Matt","Henry",31]
["John ","Mathew",28,null,"John ","Mathew",28]
["Xaka","Bender",39,null,"Xaka","Bender",39]
["Ian","Icelan",29,null,"Ian","Icelan",29]

{"sheet":"VBA-Range of Cells","index":1,"n_rows":9,"n_cols":6,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["Excel Formula to Copy Cell value to Another Cell"]
[]
["First Name","Last Name","Age",null,null,"First Name"]
["John ","Adams",21,null,null,"John "]
["Ryan ","Giggs",35,null,null,"Ryan "]
["Matt","Henry",31,null,null,"Matt"]
["John ","Mathew",28,null,null,"John "]
["Xaka","Bender",39,null,null,"Xaka"]
["Ian","Icelan",29,null,null,"Ian"]

{"sheet":"VBA-Single Cell","index":2,"n_rows":9,"n_cols":6,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["Excel Formula to Copy Cell value to Another Cell"]
[]
["First Name","Last Name","Age",null,null,"First Name"]
["John ","Adams",21]
["Ryan ","Giggs",35]
["Matt","Henry",31]
["John ","Mathew",28]
["Xaka","Bender",39]
["Ian","Icelan",29]

{"sheet":"INDEX-MATCH","index":3,"n_rows":9,"n_cols":13,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["Excel Formula to Copy Cell value to Another Cell"]
[]
["First Name","Last Name","Age",null,null,"Copy First Name","Copy Last name","Copy Age",null,null,"Copy First Name","Copy Last name","Copy Age"]
["John ","Adams",21,null,null,{"$f":"INDEX(A4,MATCH(A4,A4,0))","v":"John "},{"$f":"INDEX(B4,MATCH(B4,B4,0))","v":"Adams"},{"$f":"INDEX(C4,MATCH(C4,C4,0))","v":21}]
["Ryan ","Giggs",35,null,null,{"$f":"INDEX(A5,MATCH(A5,A5,0))","v":"Ryan "},{"$f":"INDEX(B5,MATCH(B5,B5,0))","v":"Giggs"},{"$f":"INDEX(C5,MATCH(C5,C5,0))","v":35}]
["Matt","Henry",31,null,null,"Matt","Henry",31]
["John ","Mathew",28,null,null,"John ","Mathew",28]
["Xaka","Bender",39,null,null,"Xaka","Bender",{"$f":"INDEX('VBA-Single Cell'!C8,MATCH(C8,C8,0))","v":39}]
["Ian","Icelan",29,null,null,"Ian","Icelan",29]

{"sheet":"Value-concatenate","index":4,"n_rows":9,"n_cols":8,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["Excel Formula to Copy Cell value to Another Cell"]
[]
["First Name","Last Name","Age",null,null,"Copy First Name","Copy Last name","Copy Age"]
["John ","Adams",21,null,null,{"$f":"IFERROR(VALUE(A4),CONCATENATE(A4))","v":"John "},"Adams",{"$f":"IFERROR(VALUE(C4),CONCATENATE(C4))","v":21}]
["Ryan ","Giggs",35,null,null,{"$f":"IFERROR(VALUE(A5),CONCATENATE(A5))","v":"Ryan "},{"$f":"IFERROR(VALUE(B5),CONCATENATE(B5))","v":"Giggs"},{"$f":"IFERROR(VALUE(C5),CONCATENATE(C5))","v":35}]
["Matt","Henry",31,null,null,"Matt","Henry",31]
["John ","Mathew",28,null,null,"John ","Mathew",28]
["Xaka","Bender",39,null,null,"Xaka","Bender",39]
["Ian","Icelan",29,null,null,"Ian","Icelan",29]

{"sheet":"Vlookup","index":5,"n_rows":9,"n_cols":8,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["Excel Formula to Copy Cell value to Another Cell"]
[]
["First Name","Last Name","Age",null,null,"Copy First Name","Copy Last name","Copy Age"]
["John ","Adams",21,null,null,{"$f":"VLOOKUP(A4,A4,1,FALSE)","v":"John "},{"$f":"VLOOKUP(B4,B4,1,FALSE)","v":"Adams"},21]
["Ryan ","Giggs",35,null,null,{"$f":"VLOOKUP(A5,A5,1,FALSE)","v":"Ryan "},{"$f":"VLOOKUP(B5,B5,1,FALSE)","v":"Giggs"},{"$f":"VLOOKUP(C5,C5,1,FALSE)","v":35}]
["Matt","Henry",31,null,null,"Matt","Henry",31]
["John ","Mathew",28,null,null,"John ","Mathew",28]
["Xaka","Bender",39,null,null,"Xaka","Bender",39]
["Ian","Icelan",29,null,null,"Ian","Icelan",29]

{"sheet":"Hlookup","index":6,"n_rows":9,"n_cols":8,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["Excel Formula to Copy Cell value to Another Cell"]
[]
["First Name","Last Name","Age",null,null,"Copy First Name","Copy Last name","Copy Age"]
["John ","Adams",21,null,null,{"$f":"HLOOKUP(A4,A4,1,FALSE)","v":"John "},{"$f":"HLOOKUP(B4,B4,1,FALSE)","v":"Adams"},21]
["Ryan ","Giggs",35,null,null,{"$f":"HLOOKUP(A5,A5,1,FALSE)","v":"Ryan "},{"$f":"HLOOKUP(B5,B5,1,FALSE)","v":"Giggs"},{"$f":"HLOOKUP(C5,C5,1,FALSE)","v":35}]
["Matt","Henry",31,null,null,"Matt","Henry",31]
["John ","Mathew",28,null,null,"John ","Mathew",28]
["Xaka","Bender",39,null,null,"Xaka","Bender",39]
["Ian","Icelan",29,null,null,"Ian","Icelan",29]

{"sheet":"Bonus Sheet","index":7,"n_rows":5,"n_cols":1,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["Excel Formula to Copy Cell value to Another Cell"]
[]
["Copy"]
[{"$f":"'Cell Reference'!A4","v":"John "}]
[{"$f":"HLOOKUP(Hlookup!A8,Hlookup!A8,1,FALSE)","v":"Xaka"}]