{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Problem","Solution"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":1,"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":"Problem","index":0,"n_rows":148,"n_cols":5,"rows_kept":148,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"INDEX MATCH Excel Practice Exercises"]
[]
[null,"Exercise 01 Lookup from Left to Right:"]
[null,"Order ID","Product","Price"]
[null,131402,"Laptop",1199]
[null,131403,"Mobile Phone",429]
[null,131461,"Fitness Tracker",149.94999999999999]
[null,132444,"Smart Watch",299]
[null,133409,"Tablet",715]
[null,135417,"Fitness Tracker",50]
[]
[null,"Order ID","Price"]
[null,131403]
[]
[]
[null,"Exercise 02 Lookup from Right to Left:"]
[null,"Order ID","Product","Price"]
[null,131402,"Laptop",1199]
[null,131403,"Mobile Phone",429]
[null,131461,"Fitness Tracker",149.94999999999999]
[null,132444,"Smart Watch",299]
[null,133409,"Tablet",715]
[null,135417,"Fitness Tracker",50]
[]
[null,"Price","Order ID"]
[null,50]
[]
[]
[null,"Exercise 03 Lookup Two Columns (Array Formula):"]
[null,"Order ID","Product","Price"]
[null,131402,"Laptop",1199]
[null,131403,"Mobile Phone",429]
[null,131461,"Fitness Tracker",149.94999999999999]
[null,132444,"Smart Watch",299]
[null,133409,"Laptop",715]
[null,135417,"Fitness Tracker",50]
[]
[null,"Product","Order ID","Price"]
[null,"Laptop",133409]
[]
[]
[null,"Exercise 04 Two Way Lookup:"]
[null,"Order ID","Product","Price"]
[null,131402,"Laptop",1199]
[null,131403,"Mobile Phone",429]
[null,131461,"Fitness Tracker",149.94999999999999]
[null,132444,"Smart Watch",299]
[null,133409,"Laptop",715]
[null,135417,"Fitness Tracker",50]
[]
[null,"Order ID","Column Name","Product"]
[null,133409,"Product"]
[]
[]
[null,"Exercise 05 Lookup with Partial Match:"]
[null,"Order ID","Product","Price"]
[null,131402,"Laptop",1199]
[null,131403,"Mobile Phone",429]
[null,131461,"Fitness Tracker",149.94999999999999]
[null,132444,"Smart Watch",299]
[null,133409,"Laptop",715]
[null,135417,"Fitness Tracker",50]
[]
[null,"Product","Price"]
[null,"Lap"]
[]
[]
[null,"Exercise 06 Multiple Criteria Lookup:"]
[null,"Salesman","Product","Price"]
[null,"Aaron","Laptop",1199]
[null,"Aaron","Mobile Phone",429]
[null,"Frank","Fitness Tracker",149.94999999999999]
[null,"Nathan","Smart Watch",299]
[null,"Jack","Laptop",715]
[null,"Dexter","Fitness Tracker",50]
[]
[null,"Salesman","Product","Price"]
[null,"Aaron","Mobile Phone"]
[]
[]
[null,"Exercise 07 Retrieve Values of Entire Row:"]
[null,"Salesman","Product","Price"]
[null,"Aaron","Laptop",1199]
[null,"Aaron","Mobile Phone",429]
[null,"Frank","Fitness Tracker",149.94999999999999]
[null,"Nathan","Smart Watch",299]
[null,"Jack","Laptop",715]
[null,"Dexter","Fitness Tracker",50]
[]
[]
[null,"Salesman"]
[null,"Dexter"]
[]
[null,"Salesman","Product","Product"]
[]
[]
[]
[null,"Exercise 08 Find Approximate Match:"]
[null,"Salesman","Product","Price"]
[null,"Dexter","Fitness Tracker",50]
[null,"Frank","Fitness Tracker",149.94999999999999]
[null,"Nathan","Smart Watch",299]
[null,"Aaron","Mobile Phone",429]
[null,"Jack","Laptop",715]
[null,"Aaron","Laptop",1199]
[]
[null,"Nearest Price","Product"]
[null,450]
[]
[]
[null,"Exercise 09 Multiple Criteria Without Array Formula:"]
[null,"Student","Mathematics","Chemistry","Combined Score (Helper Column)"]
[null,"Robbins",67,82]
[null,"Venus",82,87]
[null,"Hawkings",46,65]
[null,"Samuelson",63,81]
[null,"Richards",100,100]
[null,"Peter",58,90]
[]
[null,"Student"]
[]
[]
[]
[null,"Exercise 10 Use of VBA INDEX MATCH:"]
[null,"Student","Gender","Country"]
[null,"Robbins","Male","Israel"]
[null,"Venus","Female","USA"]
[null,"Hawkings","Male","Canada"]
[null,"Samuelson","Male","USA"]
[null,"Helena","Female","Hungary"]
[null,"Bailey","Female","Czech Republic"]
[]
[null,"Student","Gender","Country"]
[null,"Samuelson"]
[]
[]
[null,"Exercise 11 Find Upcoming Event:"]
[null,"Birthday Of","Date"]
[null,"Robbins","2022-08-17"]
[null,"Venus","2022-11-11"]
[null,"Hawkings","2022-12-03"]
[null,"Samuelson","2022-12-19"]
[null,"Helena","2023-01-27"]
[]
[null,"Today's Date","2022-11-14"]
[null,"Upcoming Birthday"]
[null,"Birthday Date"]

{"sheet":"Solution","index":1,"n_rows":148,"n_cols":5,"rows_kept":148,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"INDEX MATCH Excel Practice Exercises"]
[]
[null,"Exercise 01 Lookup from Left to Right:"]
[null,"Order ID","Product","Price"]
[null,131402,"Laptop",1199]
[null,131403,"Mobile Phone",429]
[null,131461,"Fitness Tracker",149.94999999999999]
[null,132444,"Smart Watch",299]
[null,133409,"Tablet",715]
[null,135417,"Fitness Tracker",50]
[]
[null,"Order ID","Price"]
[null,131403,{"$f":"INDEX(D6:D11,MATCH(B14,B6:B11,0))","v":429}]
[]
[]
[null,"Exercise 02 Lookup from Right to Left:"]
[null,"Order ID","Product","Price"]
[null,131402,"Laptop",1199]
[null,131403,"Mobile Phone",429]
[null,131461,"Fitness Tracker",149.94999999999999]
[null,132444,"Smart Watch",299]
[null,133409,"Tablet",715]
[null,135417,"Fitness Tracker",50]
[]
[null,"Price","Order ID"]
[null,50,{"$f":"INDEX(B19:B24,MATCH(B27,D19:D24,0))","v":135417}]
[]
[]
[null,"Exercise 03 Lookup Two Columns (Array Formula):"]
[null,"Order ID","Product","Price"]
[null,131402,"Laptop",1199]
[null,131403,"Mobile Phone",429]
[null,131461,"Fitness Tracker",149.94999999999999]
[null,132444,"Smart Watch",299]
[null,133409,"Laptop",715]
[null,135417,"Fitness Tracker",50]
[]
[null,"Product","Order ID","Price"]
[null,"Laptop",133409,{"$f":"INDEX(D32:D37,MATCH(B40&C40,C32:C37&B32:B37,0))","v":715}]
[]
[]
[null,"Exercise 04 Two Way Lookup:"]
[null,"Order ID","Product","Price"]
[null,131402,"Laptop",1199]
[null,131403,"Mobile Phone",429]
[null,131461,"Fitness Tracker",149.94999999999999]
[null,132444,"Smart Watch",299]
[null,133409,"Laptop",715]
[null,135417,"Fitness Tracker",50]
[]
[null,"Order ID","Column Name","Product"]
[null,133409,"Product",{"$f":"INDEX(B45:D50,MATCH(B53,B45:B50,0),MATCH(C53,B44:D44,0))","v":"Laptop"}]
[]
[]
[null,"Exercise 05 Lookup with Partial Match:"]
[null,"Order ID","Product","Price"]
[null,131402,"Laptop",1199]
[null,131403,"Mobile Phone",429]
[null,131461,"Fitness Tracker",149.94999999999999]
[null,132444,"Smart Watch",299]
[null,133409,"Laptop",715]
[null,135417,"Fitness Tracker",50]
[]
[null,"Product","Price"]
[null,"Lap",{"$f":"INDEX(D58:D63,MATCH(B66&\"*\",C58:C63,0))","v":1199}]
[]
[]
[null,"Exercise 06 Multiple Criteria Lookup:"]
[null,"Salesman","Product","Price"]
[null,"Aaron","Laptop",1199]
[null,"Aaron","Mobile Phone",429]
[null,"Frank","Fitness Tracker",149.94999999999999]
[null,"Nathan","Smart Watch",299]
[null,"Jack","Laptop",715]
[null,"Dexter","Fitness Tracker",50]
[]
[null,"Salesman","Product","Price"]
[null,"Aaron","Mobile Phone",{"$f":"INDEX(D71:D76,MATCH(1,(B79=B71:B76)*(C79=C71:C76),0))","v":429}]
[]
[]
[null,"Exercise 07 Retrieve Values of Entire Row:"]
[null,"Salesman","Product","Price"]
[null,"Aaron","Laptop",1199]
[null,"Aaron","Mobile Phone",429]
[null,"Frank","Fitness Tracker",149.94999999999999]
[null,"Nathan","Smart Watch",299]
[null,"Jack","Laptop",715]
[null,"Dexter","Fitness Tracker",50]
[]
[]
[null,"Salesman"]
[null,"Dexter"]
[]
[null,"Salesman","Product","Product"]
[null,{"$f":"INDEX(B84:D89,MATCH(B93,B84:B89,0),0)","v":"Dexter"},"Fitness Tracker",50]
[]
[]
[null,"Exercise 08 Find Approximate Match:"]
[null,"Salesman","Product","Price"]
[null,"Dexter","Fitness Tracker",50]
[null,"Frank","Fitness Tracker",149.94999999999999]
[null,"Nathan","Smart Watch",299]
[null,"Aaron","Mobile Phone",429]
[null,"Jack","Laptop",715]
[null,"Aaron","Laptop",1199]
[]
[null,"Nearest Price","Product"]
[null,450,{"$f":"INDEX(C101:C106,MATCH(B109,D101:D106,1),1)","v":"Mobile Phone"}]
[]
[]
[null,"Exercise 09 Multiple Criteria Without Array Formula:"]
[null,"Student","Mathematics","Chemistry","Combined Score (Helper Column)"]
[null,"Robbins",67,82,{"$f":"CONCATENATE(C114,\",\",D114)","v":"67,82"}]
[null,"Venus",82,87,{"$f":"CONCATENATE(C115,\",\",D115)","v":"82,87"}]
[null,"Hawkings",46,65,"46,65"]
[null,"Samuelson",63,81,"63,81"]
[null,"Richards",100,100,"100,100"]
[null,"Peter",58,90,"58,90"]
[]
[null,"Student"]
[null,{"$f":"INDEX(B114:B119,MATCH(\"100,100\",E114:E119,0))","v":"Richards"}]
[]
[]
[null,"Exercise 10 Use of VBA INDEX MATCH:"]
[null,"Student","Gender","Country"]
[null,"Robbins","Male","Israel"]
[null,"Venus","Female","USA"]
[null,"Hawkings","Male","Canada"]
[null,"Samuelson","Male","USA"]
[null,"Helena","Female","Hungary"]
[null,"Bailey","Female","Czech Republic"]
[]
[null,"Student","Gender","Country"]
[null,"Samuelson","Male","USA"]
[]
[]
[null,"Exercise 11 Find Upcoming Event:"]
[null,"Birthday Of","Date"]
[null,"Robbins","2022-08-17"]
[null,"Venus","2022-11-11"]
[null,"Hawkings","2022-12-03"]
[null,"Samuelson","2022-12-19"]
[null,"Helena","2023-01-27"]
[]
[null,"Today's Date","2022-11-14"]
[null,"Upcoming Birthday",{"$f":"INDEX($B$140:$B$144,MATCH($C$146,$C$140:$C$144,1)+1)","v":"Hawkings"}]
[null,"Birthday Date",{"$f":"INDEX(C140:C144,MATCH($C$146,$C$140:$C$144,1)+1)","v":"2022-12-03"}]