{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["Home Page","Dataset","Overview","Dependent Drop-Down List","Restricting Changes","Auto Filling List","FILTER","Non-repeating Entries","Array Formula","FILTER INDIRECT","Multiple Values","VLOOKUP"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":1,"defined_names":15,"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":"Home Page","index":0,"n_rows":30,"n_cols":3,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[null,"Populate List Based on Cell Value in Excel"]
[]
[null,"Learn how to populate a list based on cell value in Excel with this free workbook. Read the article we provided and practice these in the practice section."]
[]
[]
[null,"Prepared By","Aung Shine"]
[null,"Reviewed By","A.N.M. Mohaimen Shanto"]
[null,"Last Update","2023-10-10"]
[null,"Article Link","How to Populate List Based on Cell Value in Excel"]
[]
[null,"Methods"]
[]
[null,"1. Populating Data Validation Drop-Down List Based on Cell Value in Excel"]
[null,"    1.1 Creating Dependent Drop-Down List Using INDIRECT Function"]
[null,"    1.2 Restricting Changes in the First Drop-Down List Using IF and INDIRECT Functions"]
[null,"2. Combining INDEX, ROW, and MATCH Functions to Automatically Populate List Based on Cell Value"]
[null,"3. Inserting FILTER Function for Populating List Based on Cell Value in Excel"]
[null,"4. Combining UNIQUE and FILTER Functions to Populate the List with Non-repeating Entries"]
[null,"5. Populating List Based on Cell Value by Using Excel Array Formula"]
[null,"6. Joining FILTER and INDIRECT Functions to Populate List Based on Cell Value"]
[null,"7. Populating List Based on Multiple Cell Values in Excel"]
[null,"8. Combining IFERROR, VLOOKUP, and COLUMN Functions to Populate the List Based on Cell Value"]
[]
[]
[null,"Copyright © 2013-2023 ExcelDemy.com | All rights reserved."]

{"sheet":"Dataset","index":1,"n_rows":18,"n_cols":4,"rows_kept":18,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"How to Populate List Based on Cell Value"]
[]
[null,"Marketing","Sales","Finance"]
[null,"Marilyn Pittman","Abel Alvarado","Pablo Beck"]
[null,"Samantha Carson","Rudy Palmer","Jeffrey Casey"]
[null,"Clinton Webster","Ryan Russell","Mona Cohen"]
[null,"Chester Paul","Ramiro Harper"]
[null,"Rodney Gomez","Maggie Gilbert"]
[null,"Jaime Schultz"]
[null,"Christian Eriksen"]
[]
[]
[]
[]
[]
[]
[null,"Back to Home Page"]

{"sheet":"Overview","index":2,"n_rows":34,"n_cols":4,"rows_kept":34,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Populating List Based on Cell Value"]
[]
[null,"Marketing","Sales","Finance"]
[null,"Marilyn Pittman","Abel Alvarado","Pablo Beck"]
[null,"Samantha Carson","Rudy Palmer","Jeffrey Casey"]
[null,"Clinton Webster","Ryan Russell","Mona Cohen"]
[null,"Chester Paul","Ramiro Harper"]
[null,"Rodney Gomez","Maggie Gilbert"]
[null,"Jaime Schultz"]
[null,"Christian Eriksen"]
[]
[null,"Department","Marketing"]
[]
[null,"Employee",{"$f":"INDEX($B$4:$D$11,ROW(B2:D8),MATCH($C$13,$B$4:$D$4,0)) & \"\"","v":"Marilyn Pittman"},{"$f":"_xlfn.FORMULATEXT(C15)","v":"=INDEX($B$4:$D$11,ROW(B2:D8),MATCH($C$13,$B$4:$D$4,0)) & \"\""}]
[null,null,"Samantha Carson"]
[null,null,"Clinton Webster"]
[null,null,"Chester Paul"]
[null,null,"Rodney Gomez"]
[null,null,"Jaime Schultz"]
[null,null,"Christian Eriksen"]
[]
[null,"Employee",{"$f":"_xlfn._xlws.FILTER(B5:D11, C13=B4:D4) & \"\"","v":"Marilyn Pittman"},{"$f":"_xlfn.FORMULATEXT(C23)","v":"=FILTER(B5:D11, C13=B4:D4) & \"\""}]
[null,null,"Samantha Carson"]
[null,null,"Clinton Webster"]
[null,null,"Chester Paul"]
[null,null,"Rodney Gomez"]
[null,null,"Jaime Schultz"]
[null,null,"Christian Eriksen"]
[]
[]
[]
[]
[null,"Back to Home Page"]

{"sheet":"Dependent Drop-Down List","index":3,"n_rows":29,"n_cols":10,"rows_kept":29,"cut":false,"hidden":false,"merged":[[1,1,1,3],[3,1,3,3],[1,7,1,9],[3,7,3,9]]}
[]
[null,"Populating List Based on Cell Value",null,null,null,null,null,"Populating List Based on Cell Value"]
[]
[null,"Using INDIRECT Function",null,null,null,null,null,"Try Yourself"]
[]
[null,"Marketing","Sales","Finance",null,null,null,"Marketing","Sales","Finance"]
[null,"Marilyn Pittman","Abel Alvarado","Pablo Beck",null,null,null,"Marilyn Pittman","Abel Alvarado","Pablo Beck"]
[null,"Samantha Carson","Rudy Palmer","Jeffrey Casey",null,null,null,"Samantha Carson","Rudy Palmer","Jeffrey Casey"]
[null,"Clinton Webster","Ryan Russell","Mona Cohen",null,null,null,"Clinton Webster","Ryan Russell","Mona Cohen"]
[null,"Chester Paul","Ramiro Harper",null,null,null,null,"Chester Paul","Ramiro Harper"]
[null,"Rodney Gomez","Maggie Gilbert",null,null,null,null,"Rodney Gomez","Maggie Gilbert"]
[null,"Jaime Schultz",null,null,null,null,null,"Jaime Schultz"]
[null,"Christian Eriksen",null,null,null,null,null,"Christian Eriksen"]
[]
[null,"Department","Employee",null,null,null,null,"Department","Employee"]
[null,"Sales"]
[null,"Marketing","Chester Paul"]
[null,"Finance","Jeffrey Casey"]
[null,"Marketing","Rodney Gomez",null,{"$f":"IFERROR(INDEX($B$6:$D$13,ROW(#REF!),MATCH($B$16,$B$6:$D$6,0)),\" \")","v":" "}]
[null,"Marketing"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Back to Home Page"]

{"sheet":"Restricting Changes","index":4,"n_rows":28,"n_cols":10,"rows_kept":28,"cut":false,"hidden":false,"merged":[[1,1,1,3],[3,1,3,3],[1,7,1,9],[3,7,3,9]]}
[]
[null,"Populating List Based on Cell Value",null,null,null,null,null,"Populating List Based on Cell Value"]
[]
[null,"Using IF and INDIRECT Functions",null,null,null,null,null,"Try Yourself"]
[]
[null,"Marketing","Sales","Finance",null,null,null,"Marketing","Sales","Finance"]
[null,"Marilyn Pittman","Abel Alvarado","Pablo Beck",null,null,null,"Marilyn Pittman","Abel Alvarado","Pablo Beck"]
[null,"Samantha Carson","Rudy Palmer","Jeffrey Casey",null,null,null,"Samantha Carson","Rudy Palmer","Jeffrey Casey"]
[null,"Clinton Webster","Ryan Russell","Mona Cohen",null,null,null,"Clinton Webster","Ryan Russell","Mona Cohen"]
[null,"Chester Paul","Ramiro Harper",null,null,null,null,"Chester Paul","Ramiro Harper"]
[null,"Rodney Gomez","Maggie Gilbert",null,null,null,null,"Rodney Gomez","Maggie Gilbert"]
[null,"Jaime Schultz",null,null,null,null,null,"Jaime Schultz"]
[null,"Christian Eriksen",null,null,null,null,null,"Christian Eriksen"]
[]
[null,"Department","Employee",null,null,null,null,"Department","Employee"]
[null,"Marketing","Samantha Carson"]
[null,"Sales","Maggie Gilbert"]
[null,"Finance","Mona Cohen"]
[null,"Sales","Ryan Russell",null,{"$f":"IFERROR(INDEX($B$6:$D$13,ROW(#REF!),MATCH($B$16,$B$6:$D$6,0)),\" \")","v":" "}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Back to Home Page"]

{"sheet":"Auto Filling List","index":5,"n_rows":28,"n_cols":12,"rows_kept":28,"cut":false,"hidden":false,"merged":[[1,1,1,3],[3,1,3,3],[1,8,1,10],[3,8,3,10]]}
[]
[null,"Populating List Based on Cell Value",null,null,null,null,null,null,"Populating List Based on Cell Value"]
[]
[null,"Combining INDEX, ROW, and MATCH Functions",null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Marketing","Sales","Finance",null,null,null,null,"Marketing","Sales","Finance"]
[null,"Marilyn Pittman","Abel Alvarado","Pablo Beck",null,null,null,null,"Marilyn Pittman","Abel Alvarado","Pablo Beck"]
[null,"Samantha Carson","Rudy Palmer","Jeffrey Casey",null,null,null,null,"Samantha Carson","Rudy Palmer","Jeffrey Casey"]
[null,"Clinton Webster","Ryan Russell","Mona Cohen",null,null,null,null,"Clinton Webster","Ryan Russell","Mona Cohen"]
[null,"Chester Paul","Ramiro Harper",null,null,null,null,null,"Chester Paul","Ramiro Harper"]
[null,"Rodney Gomez","Maggie Gilbert",null,null,null,null,null,"Rodney Gomez","Maggie Gilbert"]
[null,"Jaime Schultz",null,null,null,null,null,null,"Jaime Schultz"]
[null,"Christian Eriksen",null,null,null,null,null,null,"Christian Eriksen"]
[]
[null,"Department","Finance",null,null,null,null,null,"Department","Finance"]
[]
[null,null,"Using INDEX, ROW, MATCH, and & Operator","Using IF, INDEX, ROW, and MATCH Functions","Using IFERROR, INDEX, ROW, and MATCH",null,null,null,null,"Using INDEX, ROW, MATCH, and & Operator","Using IF, INDEX, ROW, and MATCH Functions","Using IFERROR, INDEX, ROW, and MATCH"]
[null,"Employee",{"$f":"INDEX($B$6:$D$13,ROW(B2:D8),MATCH($C$15,$B$6:$D$6,0)) & \"\"","v":"Pablo Beck"},{"$f":"IF(INDEX($B$6:$D$13,ROW(B2:D8),MATCH($C$15,$B$6:$D$6,0))<>0, INDEX($B$6:$D$13,ROW(B2:D8),MATCH($C$15,$B$6:$D$6,0)), \"\")","v":"Pablo Beck"},{"$f":"IFERROR(INDEX($B$6:$D$13,ROW(B2:D8),MATCH($C$15,$B$6:$D$6,0)), \"\")","v":"Pablo Beck"},null,null,null,"Employee"]
[null,null,"Jeffrey Casey","Jeffrey Casey","Jeffrey Casey"]
[null,null,"Mona Cohen","Mona Cohen","Mona Cohen"]
[null,null,"","",0]
[null,null,"","",0]
[null,null,"","",0]
[null,null,"","",0]
[]
[]
[]
[null,"Back to Home Page"]

{"sheet":"FILTER","index":6,"n_rows":31,"n_cols":11,"rows_kept":31,"cut":false,"hidden":false,"merged":[[1,1,1,3],[3,1,3,3],[1,8,1,10],[3,8,3,10]]}
[]
[null,"Populating List Based on Cell Value",null,null,null,null,null,null,"Populating List Based on Cell Value"]
[]
[null,"Using FILTER Function",null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Marketing","Sales","Finance",null,null,null,null,"Marketing","Sales","Finance"]
[null,"Marilyn Pittman","Abel Alvarado","Pablo Beck",null,null,null,null,"Marilyn Pittman","Abel Alvarado","Pablo Beck"]
[null,"Samantha Carson","Rudy Palmer","Jeffrey Casey",null,null,null,null,"Samantha Carson","Rudy Palmer","Jeffrey Casey"]
[null,"Clinton Webster","Ryan Russell","Mona Cohen",null,null,null,null,"Clinton Webster","Ryan Russell","Mona Cohen"]
[null,"Chester Paul","Ramiro Harper",null,null,null,null,null,"Chester Paul","Ramiro Harper"]
[null,"Rodney Gomez","Maggie Gilbert",null,null,null,null,null,"Rodney Gomez","Maggie Gilbert"]
[null,"Jaime Schultz",null,null,null,null,null,null,"Jaime Schultz"]
[null,"Christian Eriksen",null,null,null,null,null,null,"Christian Eriksen"]
[]
[null,"Department","Marketing",null,null,null,null,null,"Department","Sales"]
[]
[null,"Employee",{"$f":"_xlfn._xlws.FILTER(B7:D13, C15=B6:D6) & \"\"","v":"Marilyn Pittman"},null,null,null,null,null,"Employee"]
[null,null,"Samantha Carson"]
[null,null,"Clinton Webster"]
[null,null,"Chester Paul"]
[null,null,"Rodney Gomez"]
[null,null,"Jaime Schultz"]
[null,null,"Christian Eriksen"]
[]
[]
[]
[]
[]
[]
[]
[null,"Back to Home Page"]

{"sheet":"Non-repeating Entries","index":7,"n_rows":27,"n_cols":10,"rows_kept":27,"cut":false,"hidden":false,"merged":[[1,1,1,3],[3,1,3,3],[1,7,1,9],[3,7,3,9]]}
[]
[null,"Populating List Based on Cell Value",null,null,null,null,null,"Populating List Based on Cell Value"]
[]
[null,"Combining UNIQUE and FILTER Functions",null,null,null,null,null,"Try Yourself"]
[]
[null,"Marketing","Sales","Finance",null,null,null,"Marketing","Sales","Finance"]
[null,"Marilyn Pittman","Abel Alvarado","Pablo Beck",null,null,null,"Marilyn Pittman","Abel Alvarado","Pablo Beck"]
[null,"Samantha Carson","Rudy Palmer","Pablo Beck",null,null,null,"Samantha Carson","Rudy Palmer","Pablo Beck"]
[null,"Clinton Webster","Ramiro Harper","Mona Cohen",null,null,null,"Clinton Webster","Ramiro Harper","Mona Cohen"]
[null,"Chester Paul","Ramiro Harper",null,null,null,null,"Chester Paul","Ramiro Harper"]
[null,"Chester Paul",null,null,null,null,null,"Chester Paul"]
[null,"Jaime Schultz",null,null,null,null,null,"Jaime Schultz"]
[null,"Christian Eriksen",null,null,null,null,null,"Christian Eriksen"]
[]
[null,"Department","Finance",null,null,null,null,"Department","Sales"]
[]
[null,"Employee",{"$f":"_xlfn.UNIQUE(_xlfn._xlws.FILTER(B7:D13, C15=B6:D6)) & \"\"","v":"Pablo Beck"},null,null,null,null,"Employee"]
[null,null,"Mona Cohen"]
[null,null,""]
[]
[]
[]
[]
[]
[]
[]
[null,"Back to Home Page"]

{"sheet":"Array Formula","index":8,"n_rows":33,"n_cols":12,"rows_kept":33,"cut":false,"hidden":false,"merged":[[1,1,1,4],[3,1,3,4],[1,8,1,11],[3,8,3,11]]}
[]
[null,"Populating List Based on Cell Value",null,null,null,null,null,null,"Populating List Based on Cell Value"]
[]
[null,"Using Array Formula",null,null,null,null,null,null,"Try Yourself"]
[]
[null,"ID","Brand","Model","Unit Price",null,null,null,"ID","Brand","Model","Unit Price"]
[null,"AP-1122","APPLE","IPHONE 15 PRO",1200,null,null,null,"AP-1122","APPLE","IPHONE 15 PRO",1200]
[null,"SM-1133","SAMSUNG","GALAXY NOTE 22",1100,null,null,null,"SM-1133","SAMSUNG","GALAXY NOTE 22",1100]
[null,"SM-1144","SAMSUNG","GALAXY NOTE 21",1000,null,null,null,"SM-1144","SAMSUNG","GALAXY NOTE 21",1000]
[null,"AP-1144","APPLE","IPHONE 14",1150,null,null,null,"AP-1144","APPLE","IPHONE 14",1150]
[null,"AP-1166","APPLE","IPHONE 13",850,null,null,null,"AP-1166","APPLE","IPHONE 13",850]
[null,"SN-1177","SONY","XPERIA XZ3 ",650,null,null,null,"SN-1177","SONY","XPERIA XZ3 ",650]
[null,"OP-1188","ONEPLUS","8T",450,null,null,null,"OP-1188","ONEPLUS","8T",450]
[null,"SM-2200","SAMSUNG","GALAXY NOTE 10",850,null,null,null,"SM-2200","SAMSUNG","GALAXY NOTE 10",850]
[]
[null,"Brand Name","ONEPLUS",null,null,null,null,null,"Brand Name","ONEPLUS"]
[]
[null,"ID","Brand","Model","Unit Price",null,null,null,"ID","Brand","Model","Unit Price"]
[null,{"$f":"IFERROR(INDEX($B$7:$E$14, SMALL(IF(COUNTIF($C$16:$C$17,$C$7:$C$14),\nMATCH(ROW($B$7:$E$14), ROW($B$7:$E$14)), \"\"), ROWS(B19:$B$19)),\nCOLUMNS($B$6:B6)),\"\")","v":"OP-1188"},{"$f":"IFERROR(INDEX($B$7:$E$14, SMALL(IF(COUNTIF($C$16:$C$17,$C$7:$C$14),\nMATCH(ROW($B$7:$E$14), ROW($B$7:$E$14)), \"\"), ROWS($B19:C$19)),\nCOLUMNS($B$6:C6)),\"\")","v":"ONEPLUS"},{"$f":"IFERROR(INDEX($B$7:$E$14, SMALL(IF(COUNTIF($C$16:$C$17,$C$7:$C$14),\nMATCH(ROW($B$7:$E$14), ROW($B$7:$E$14)), \"\"), ROWS($B19:D$19)),\nCOLUMNS($B$6:D6)),\"\")","v":"8T"},{"$f":"IFERROR(INDEX($B$7:$E$14, SMALL(IF(COUNTIF($C$16:$C$17,$C$7:$C$14),\nMATCH(ROW($B$7:$E$14), ROW($B$7:$E$14)), \"\"), ROWS($B19:E$19)),\nCOLUMNS($B$6:E6)),\"\")","v":450},{"$f":"IFERROR(INDEX($B$7:$E$14, SMALL(IF(COUNTIF($B$17:$B$20,$C$7:$C$14), MATCH(ROW($B$7:$E$14), ROW($B$7:$E$14)), \"\"), ROWS($C19:F$19)), COLUMNS($B$6:E6)),\"\")","v":""},null,{"$f":"IFERROR(INDEX($B$7:$E$14, SMALL(IF(COUNTIF($B$17:$B$20,$C$7:$C$14), MATCH(ROW($B$7:$E$14), ROW($B$7:$E$14)), \"\"), ROWS($C19:H$19)), COLUMNS($B$6:G6)),\"\")","v":""}]
[null,{"$f":"IFERROR(INDEX($B$7:$E$14, SMALL(IF(COUNTIF($C$16:$C$17,$C$7:$C$14),\nMATCH(ROW($B$7:$E$14), ROW($B$7:$E$14)), \"\"), ROWS(B$19:$B20)),\nCOLUMNS($B$6:B7)),\"\")","v":""},{"$f":"IFERROR(INDEX($B$7:$E$14, SMALL(IF(COUNTIF($C$16:$C$17,$C$7:$C$14),\nMATCH(ROW($B$7:$E$14), ROW($B$7:$E$14)), \"\"), ROWS($B$19:C20)),\nCOLUMNS($B$6:C7)),\"\")","v":""},{"$f":"IFERROR(INDEX($B$7:$E$14, SMALL(IF(COUNTIF($C$16:$C$17,$C$7:$C$14),\nMATCH(ROW($B$7:$E$14), ROW($B$7:$E$14)), \"\"), ROWS($B$19:D20)),\nCOLUMNS($B$6:D7)),\"\")","v":""},{"$f":"IFERROR(INDEX($B$7:$E$14, SMALL(IF(COUNTIF($C$16:$C$17,$C$7:$C$14),\nMATCH(ROW($B$7:$E$14), ROW($B$7:$E$14)), \"\"), ROWS($B$19:E20)),\nCOLUMNS($B$6:E7)),\"\")","v":""},{"$f":"IFERROR(INDEX($B$7:$E$14, SMALL(IF(COUNTIF($B$17:$B$20,$C$7:$C$14), MATCH(ROW($B$7:$E$14), ROW($B$7:$E$14)), \"\"), ROWS($C$19:F20)), COLUMNS($B$6:E7)),\"\")","v":""}]
[null,{"$f":"IFERROR(INDEX($B$7:$E$14, SMALL(IF(COUNTIF($C$16:$C$17,$C$7:$C$14),\nMATCH(ROW($B$7:$E$14), ROW($B$7:$E$14)), \"\"), ROWS(B$19:$B21)),\nCOLUMNS($B$6:B8)),\"\")","v":""},{"$f":"IFERROR(INDEX($B$7:$E$14, SMALL(IF(COUNTIF($C$16:$C$17,$C$7:$C$14),\nMATCH(ROW($B$7:$E$14), ROW($B$7:$E$14)), \"\"), ROWS($B$19:C21)),\nCOLUMNS($B$6:C8)),\"\")","v":""},{"$f":"IFERROR(INDEX($B$7:$E$14, SMALL(IF(COUNTIF($C$16:$C$17,$C$7:$C$14),\nMATCH(ROW($B$7:$E$14), ROW($B$7:$E$14)), \"\"), ROWS($B$19:D21)),\nCOLUMNS($B$6:D8)),\"\")","v":""},{"$f":"IFERROR(INDEX($B$7:$E$14, SMALL(IF(COUNTIF($C$16:$C$17,$C$7:$C$14),\nMATCH(ROW($B$7:$E$14), ROW($B$7:$E$14)), \"\"), ROWS($B$19:E21)),\nCOLUMNS($B$6:E8)),\"\")","v":""},{"$f":"IFERROR(INDEX($B$7:$E$14, SMALL(IF(COUNTIF($B$17:$B$20,$C$7:$C$14), MATCH(ROW($B$7:$E$14), ROW($B$7:$E$14)), \"\"), ROWS($C$19:F21)), COLUMNS($B$6:E8)),\"\")","v":""}]
[null,{"$f":"IFERROR(INDEX($B$7:$E$14, SMALL(IF(COUNTIF($C$16:$C$17,$C$7:$C$14),\nMATCH(ROW($B$7:$E$14), ROW($B$7:$E$14)), \"\"), ROWS(B$19:$B22)),\nCOLUMNS($B$6:B9)),\"\")","v":""},{"$f":"IFERROR(INDEX($B$7:$E$14, SMALL(IF(COUNTIF($C$16:$C$17,$C$7:$C$14),\nMATCH(ROW($B$7:$E$14), ROW($B$7:$E$14)), \"\"), ROWS($B$19:C22)),\nCOLUMNS($B$6:C9)),\"\")","v":""},{"$f":"IFERROR(INDEX($B$7:$E$14, SMALL(IF(COUNTIF($C$16:$C$17,$C$7:$C$14),\nMATCH(ROW($B$7:$E$14), ROW($B$7:$E$14)), \"\"), ROWS($B$19:D22)),\nCOLUMNS($B$6:D9)),\"\")","v":""},{"$f":"IFERROR(INDEX($B$7:$E$14, SMALL(IF(COUNTIF($C$16:$C$17,$C$7:$C$14),\nMATCH(ROW($B$7:$E$14), ROW($B$7:$E$14)), \"\"), ROWS($B$19:E22)),\nCOLUMNS($B$6:E9)),\"\")","v":""},{"$f":"IFERROR(INDEX($B$7:$E$14, SMALL(IF(COUNTIF($B$17:$B$20,$C$7:$C$14), MATCH(ROW($B$7:$E$14), ROW($B$7:$E$14)), \"\"), ROWS($C$19:F22)), COLUMNS($B$6:E9)),\"\")","v":""}]
[null,{"$f":"IFERROR(INDEX($B$7:$E$14, SMALL(IF(COUNTIF($C$16:$C$17,$C$7:$C$14),\nMATCH(ROW($B$7:$E$14), ROW($B$7:$E$14)), \"\"), ROWS(B$19:$B23)),\nCOLUMNS($B$6:B10)),\"\")","v":""},{"$f":"IFERROR(INDEX($B$7:$E$14, SMALL(IF(COUNTIF($C$16:$C$17,$C$7:$C$14),\nMATCH(ROW($B$7:$E$14), ROW($B$7:$E$14)), \"\"), ROWS($B$19:C23)),\nCOLUMNS($B$6:C10)),\"\")","v":""},{"$f":"IFERROR(INDEX($B$7:$E$14, SMALL(IF(COUNTIF($C$16:$C$17,$C$7:$C$14),\nMATCH(ROW($B$7:$E$14), ROW($B$7:$E$14)), \"\"), ROWS($B$19:D23)),\nCOLUMNS($B$6:D10)),\"\")","v":""},{"$f":"IFERROR(INDEX($B$7:$E$14, SMALL(IF(COUNTIF($C$16:$C$17,$C$7:$C$14),\nMATCH(ROW($B$7:$E$14), ROW($B$7:$E$14)), \"\"), ROWS($B$19:E23)),\nCOLUMNS($B$6:E10)),\"\")","v":""},{"$f":"IFERROR(INDEX($B$7:$E$14, SMALL(IF(COUNTIF($B$17:$B$20,$C$7:$C$14), MATCH(ROW($B$7:$E$14), ROW($B$7:$E$14)), \"\"), ROWS($C$19:F23)), COLUMNS($B$6:E10)),\"\")","v":""}]
[null,{"$f":"IFERROR(INDEX($B$7:$E$14, SMALL(IF(COUNTIF($C$16:$C$17,$C$7:$C$14),\nMATCH(ROW($B$7:$E$14), ROW($B$7:$E$14)), \"\"), ROWS(B$19:$B24)),\nCOLUMNS($B$6:B11)),\"\")","v":""},{"$f":"IFERROR(INDEX($B$7:$E$14, SMALL(IF(COUNTIF($C$16:$C$17,$C$7:$C$14),\nMATCH(ROW($B$7:$E$14), ROW($B$7:$E$14)), \"\"), ROWS($B$19:C24)),\nCOLUMNS($B$6:C11)),\"\")","v":""},{"$f":"IFERROR(INDEX($B$7:$E$14, SMALL(IF(COUNTIF($C$16:$C$17,$C$7:$C$14),\nMATCH(ROW($B$7:$E$14), ROW($B$7:$E$14)), \"\"), ROWS($B$19:D24)),\nCOLUMNS($B$6:D11)),\"\")","v":""},{"$f":"IFERROR(INDEX($B$7:$E$14, SMALL(IF(COUNTIF($C$16:$C$17,$C$7:$C$14),\nMATCH(ROW($B$7:$E$14), ROW($B$7:$E$14)), \"\"), ROWS($B$19:E24)),\nCOLUMNS($B$6:E11)),\"\")","v":""},{"$f":"IFERROR(INDEX($B$7:$E$14, SMALL(IF(COUNTIF($B$17:$B$20,$C$7:$C$14), MATCH(ROW($B$7:$E$14), ROW($B$7:$E$14)), \"\"), ROWS($C$19:F24)), COLUMNS($B$6:E11)),\"\")","v":""}]
[null,{"$f":"IFERROR(INDEX($B$7:$E$14, SMALL(IF(COUNTIF($C$16:$C$17,$C$7:$C$14),\nMATCH(ROW($B$7:$E$14), ROW($B$7:$E$14)), \"\"), ROWS(B$19:$B25)),\nCOLUMNS($B$6:B12)),\"\")","v":""},{"$f":"IFERROR(INDEX($B$7:$E$14, SMALL(IF(COUNTIF($C$16:$C$17,$C$7:$C$14),\nMATCH(ROW($B$7:$E$14), ROW($B$7:$E$14)), \"\"), ROWS($B$19:C25)),\nCOLUMNS($B$6:C12)),\"\")","v":""},{"$f":"IFERROR(INDEX($B$7:$E$14, SMALL(IF(COUNTIF($C$16:$C$17,$C$7:$C$14),\nMATCH(ROW($B$7:$E$14), ROW($B$7:$E$14)), \"\"), ROWS($B$19:D25)),\nCOLUMNS($B$6:D12)),\"\")","v":""},{"$f":"IFERROR(INDEX($B$7:$E$14, SMALL(IF(COUNTIF($C$16:$C$17,$C$7:$C$14),\nMATCH(ROW($B$7:$E$14), ROW($B$7:$E$14)), \"\"), ROWS($B$19:E25)),\nCOLUMNS($B$6:E12)),\"\")","v":""},{"$f":"IFERROR(INDEX($B$7:$E$14, SMALL(IF(COUNTIF($B$17:$B$20,$C$7:$C$14), MATCH(ROW($B$7:$E$14), ROW($B$7:$E$14)), \"\"), ROWS($C$19:F25)), COLUMNS($B$6:E12)),\"\")","v":""}]
[null,{"$f":"IFERROR(INDEX($B$7:$E$14, SMALL(IF(COUNTIF($C$16:$C$17,$C$7:$C$14), MATCH(ROW($B$7:$E$14), ROW($B$7:$E$14)), \"\"), ROWS(B$19:$B26)), COLUMNS($B$6:B13)),\"\")","v":""},{"$f":"IFERROR(INDEX($B$7:$E$14, SMALL(IF(COUNTIF($C$16:$C$17,$C$7:$C$14), MATCH(ROW($B$7:$E$14), ROW($B$7:$E$14)), \"\"), ROWS($B$19:C26)), COLUMNS($B$6:C13)),\"\")","v":""},{"$f":"IFERROR(INDEX($B$7:$E$14, SMALL(IF(COUNTIF($C$16:$C$17,$C$7:$C$14), MATCH(ROW($B$7:$E$14), ROW($B$7:$E$14)), \"\"), ROWS($B$19:D26)), COLUMNS($B$6:D13)),\"\")","v":""},{"$f":"IFERROR(INDEX($B$7:$E$14, SMALL(IF(COUNTIF($C$16:$C$17,$C$7:$C$14), MATCH(ROW($B$7:$E$14), ROW($B$7:$E$14)), \"\"), ROWS($B$19:E26)), COLUMNS($B$6:E13)),\"\")","v":""},{"$f":"IFERROR(INDEX($B$7:$E$14, SMALL(IF(COUNTIF($B$17:$B$20,$C$7:$C$14), MATCH(ROW($B$7:$E$14), ROW($B$7:$E$14)), \"\"), ROWS($C$19:F26)), COLUMNS($B$6:E13)),\"\")","v":""}]
[null,{"$f":"IFERROR(INDEX($B$7:$E$14, SMALL(IF(COUNTIF($C$16:$C$17,$C$7:$C$14), MATCH(ROW($B$7:$E$14), ROW($B$7:$E$14)), \"\"), ROWS(B$19:$B27)), COLUMNS($B$6:B14)),\"\")","v":""},{"$f":"IFERROR(INDEX($B$7:$E$14, SMALL(IF(COUNTIF($C$16:$C$17,$C$7:$C$14), MATCH(ROW($B$7:$E$14), ROW($B$7:$E$14)), \"\"), ROWS($B$19:C27)), COLUMNS($B$6:C14)),\"\")","v":""},{"$f":"IFERROR(INDEX($B$7:$E$14, SMALL(IF(COUNTIF($C$16:$C$17,$C$7:$C$14), MATCH(ROW($B$7:$E$14), ROW($B$7:$E$14)), \"\"), ROWS($B$19:D27)), COLUMNS($B$6:D14)),\"\")","v":""},{"$f":"IFERROR(INDEX($B$7:$E$14, SMALL(IF(COUNTIF($C$16:$C$17,$C$7:$C$14), MATCH(ROW($B$7:$E$14), ROW($B$7:$E$14)), \"\"), ROWS($B$19:E27)), COLUMNS($B$6:E14)),\"\")","v":""}]
[null,"Back to Home Page",{"$f":"IFERROR(INDEX($B$7:$E$14, SMALL(IF(COUNTIF($C$16:$C$17,$C$7:$C$14), MATCH(ROW($B$7:$E$14), ROW($B$7:$E$14)), \"\"), ROWS($B$19:C28)), COLUMNS($B$6:C15)),\"\")","v":""},{"$f":"IFERROR(INDEX($B$7:$E$14, SMALL(IF(COUNTIF($C$16:$C$17,$C$7:$C$14), MATCH(ROW($B$7:$E$14), ROW($B$7:$E$14)), \"\"), ROWS($B$19:D28)), COLUMNS($B$6:D15)),\"\")","v":""},{"$f":"IFERROR(INDEX($B$7:$E$14, SMALL(IF(COUNTIF($C$16:$C$17,$C$7:$C$14), MATCH(ROW($B$7:$E$14), ROW($B$7:$E$14)), \"\"), ROWS($B$19:E28)), COLUMNS($B$6:E15)),\"\")","v":""}]
[null,{"$f":"IFERROR(INDEX($B$7:$E$14, SMALL(IF(COUNTIF($C$16:$C$17,$C$7:$C$14), MATCH(ROW($B$7:$E$14), ROW($B$7:$E$14)), \"\"), ROWS(B$19:$B29)), COLUMNS($B$6:B16)),\"\")","v":""},{"$f":"IFERROR(INDEX($B$7:$E$14, SMALL(IF(COUNTIF($C$16:$C$17,$C$7:$C$14), MATCH(ROW($B$7:$E$14), ROW($B$7:$E$14)), \"\"), ROWS($B$19:C29)), COLUMNS($B$6:C16)),\"\")","v":""},{"$f":"IFERROR(INDEX($B$7:$E$14, SMALL(IF(COUNTIF($C$16:$C$17,$C$7:$C$14), MATCH(ROW($B$7:$E$14), ROW($B$7:$E$14)), \"\"), ROWS($B$19:D29)), COLUMNS($B$6:D16)),\"\")","v":""},{"$f":"IFERROR(INDEX($B$7:$E$14, SMALL(IF(COUNTIF($C$16:$C$17,$C$7:$C$14), MATCH(ROW($B$7:$E$14), ROW($B$7:$E$14)), \"\"), ROWS($B$19:E29)), COLUMNS($B$6:E16)),\"\")","v":""}]
[null,{"$f":"IFERROR(INDEX($B$7:$E$14, SMALL(IF(COUNTIF($C$16:$C$17,$C$7:$C$14), MATCH(ROW($B$7:$E$14), ROW($B$7:$E$14)), \"\"), ROWS(B$19:$B30)), COLUMNS($B$6:B17)),\"\")","v":""},{"$f":"IFERROR(INDEX($B$7:$E$14, SMALL(IF(COUNTIF($C$16:$C$17,$C$7:$C$14), MATCH(ROW($B$7:$E$14), ROW($B$7:$E$14)), \"\"), ROWS($B$19:C30)), COLUMNS($B$6:C17)),\"\")","v":""},{"$f":"IFERROR(INDEX($B$7:$E$14, SMALL(IF(COUNTIF($C$16:$C$17,$C$7:$C$14), MATCH(ROW($B$7:$E$14), ROW($B$7:$E$14)), \"\"), ROWS($B$19:D30)), COLUMNS($B$6:D17)),\"\")","v":""},{"$f":"IFERROR(INDEX($B$7:$E$14, SMALL(IF(COUNTIF($C$16:$C$17,$C$7:$C$14), MATCH(ROW($B$7:$E$14), ROW($B$7:$E$14)), \"\"), ROWS($B$19:E30)), COLUMNS($B$6:E17)),\"\")","v":""}]
[null,{"$f":"IFERROR(INDEX($B$7:$E$14, SMALL(IF(COUNTIF($C$16:$C$17,$C$7:$C$14), MATCH(ROW($B$7:$E$14), ROW($B$7:$E$14)), \"\"), ROWS(B$19:$B31)), COLUMNS($B$6:B18)),\"\")","v":""},{"$f":"IFERROR(INDEX($B$7:$E$14, SMALL(IF(COUNTIF($C$16:$C$17,$C$7:$C$14), MATCH(ROW($B$7:$E$14), ROW($B$7:$E$14)), \"\"), ROWS($B$19:C31)), COLUMNS($B$6:C18)),\"\")","v":""},{"$f":"IFERROR(INDEX($B$7:$E$14, SMALL(IF(COUNTIF($C$16:$C$17,$C$7:$C$14), MATCH(ROW($B$7:$E$14), ROW($B$7:$E$14)), \"\"), ROWS($B$19:D31)), COLUMNS($B$6:D18)),\"\")","v":""},{"$f":"IFERROR(INDEX($B$7:$E$14, SMALL(IF(COUNTIF($C$16:$C$17,$C$7:$C$14), MATCH(ROW($B$7:$E$14), ROW($B$7:$E$14)), \"\"), ROWS($B$19:E31)), COLUMNS($B$6:E18)),\"\")","v":""}]
[null,{"$f":"IFERROR(INDEX($B$7:$E$14, SMALL(IF(COUNTIF($C$16:$C$17,$C$7:$C$14), MATCH(ROW($B$7:$E$14), ROW($B$7:$E$14)), \"\"), ROWS(B$19:$B32)), COLUMNS($B$6:B19)),\"\")","v":""},{"$f":"IFERROR(INDEX($B$7:$E$14, SMALL(IF(COUNTIF($C$16:$C$17,$C$7:$C$14), MATCH(ROW($B$7:$E$14), ROW($B$7:$E$14)), \"\"), ROWS($B$19:C32)), COLUMNS($B$6:C19)),\"\")","v":""},{"$f":"IFERROR(INDEX($B$7:$E$14, SMALL(IF(COUNTIF($C$16:$C$17,$C$7:$C$14), MATCH(ROW($B$7:$E$14), ROW($B$7:$E$14)), \"\"), ROWS($B$19:D32)), COLUMNS($B$6:D19)),\"\")","v":""},{"$f":"IFERROR(INDEX($B$7:$E$14, SMALL(IF(COUNTIF($C$16:$C$17,$C$7:$C$14), MATCH(ROW($B$7:$E$14), ROW($B$7:$E$14)), \"\"), ROWS($B$19:E32)), COLUMNS($B$6:E19)),\"\")","v":""}]
[null,{"$f":"IFERROR(INDEX($B$7:$E$14, SMALL(IF(COUNTIF($C$16:$C$17,$C$7:$C$14), MATCH(ROW($B$7:$E$14), ROW($B$7:$E$14)), \"\"), ROWS(B$19:$B33)), COLUMNS($B$6:B20)),\"\")","v":""},{"$f":"IFERROR(INDEX($B$7:$E$14, SMALL(IF(COUNTIF($C$16:$C$17,$C$7:$C$14), MATCH(ROW($B$7:$E$14), ROW($B$7:$E$14)), \"\"), ROWS($B$19:C33)), COLUMNS($B$6:C20)),\"\")","v":""},{"$f":"IFERROR(INDEX($B$7:$E$14, SMALL(IF(COUNTIF($C$16:$C$17,$C$7:$C$14), MATCH(ROW($B$7:$E$14), ROW($B$7:$E$14)), \"\"), ROWS($B$19:D33)), COLUMNS($B$6:D20)),\"\")","v":""},{"$f":"IFERROR(INDEX($B$7:$E$14, SMALL(IF(COUNTIF($C$16:$C$17,$C$7:$C$14), MATCH(ROW($B$7:$E$14), ROW($B$7:$E$14)), \"\"), ROWS($B$19:E33)), COLUMNS($B$6:E20)),\"\")","v":""}]

{"sheet":"FILTER INDIRECT","index":9,"n_rows":26,"n_cols":17,"rows_kept":26,"cut":false,"hidden":false,"merged":[[1,1,1,7],[3,1,3,7],[1,10,1,16],[3,10,3,16]]}
[]
[null,"Populating List Based on Cell Value",null,null,null,null,null,null,null,null,"Populating List Based on Cell Value"]
[]
[null,"Joining FILTER and INDIRECT Functions",null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Token No.","Samantha","Rudy","Jeffrey",null,"Name","Samantha",null,null,"Token No.","Samantha","Rudy","Jeffrey",null,"Name","Rudy"]
[null,"B10","x",null,null,null,null,null,null,null,"B10","x"]
[null,"K30",null,"x",null,null,"Token No.",{"$f":"_xlfn._xlws.FILTER(Table1[Token No.],INDIRECT(\"Table1[\"&H6&\"]\")=\"x\")","v":"B10"},null,null,"K30",null,"x",null,null,"Token No."]
[null,"H50",null,null,"x",null,null,"B11",null,null,"H50",null,null,"x"]
[null,"B11","x",null,null,null,null,"B12",null,null,"B11","x"]
[null,"K31",null,"x",null,null,null,null,null,null,"K31",null,"x"]
[null,"H51",null,null,"x",null,null,null,null,null,"H51",null,null,"x"]
[null,"K32",null,null,null,null,null,null,null,null,"K32"]
[null,"H52",null,"x","x",null,null,null,null,null,"H52",null,"x","x"]
[null,"B12","x",null,null,null,null,null,null,null,"B12","x"]
[null,"K33",null,"x",null,null,null,null,null,null,"K33",null,"x"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Back to Home Page"]

{"sheet":"Multiple Values","index":10,"n_rows":27,"n_cols":12,"rows_kept":27,"cut":false,"hidden":false,"merged":[[1,1,1,4],[3,1,3,4],[1,8,1,11],[3,8,3,11]]}
[]
[null,"Populating List Based on Cell Values",null,null,null,null,null,null,"Populating List Based on Cell Values"]
[]
[null,"Combining Multiple Functions",null,null,null,null,null,null,"Try Yourself"]
[]
[null,"ID","Brand","Model","Unit Price",null,null,null,"ID","Brand","Model","Unit Price"]
[null,"AP-1122","APPLE","IPHONE 15 PRO",1200,null,null,null,"AP-1122","APPLE","IPHONE 15 PRO",1200]
[null,"SM-1133","SAMSUNG","GALAXY NOTE 22",1100,null,null,null,"SM-1133","SAMSUNG","GALAXY NOTE 22",1100]
[null,"SM-1144","SAMSUNG","GALAXY NOTE 21",950,null,null,null,"SM-1144","SAMSUNG","GALAXY NOTE 21",950]
[null,"AP-1144","APPLE","IPHONE 14",900,null,null,null,"AP-1144","APPLE","IPHONE 14",900]
[null,"AP-1166","APPLE","IPHONE 13",800,null,null,null,"AP-1166","APPLE","IPHONE 13",800]
[null,"SM-1177","SAMSUNG","GALAXY NOTE 23",1200,null,null,null,"SM-1177","SAMSUNG","GALAXY NOTE 23",1200]
[null,"AP-1188","APPLE","IPHONE 14 PRO",1000,null,null,null,"AP-1188","APPLE","IPHONE 14 PRO",1000]
[null,"SM-2200","SAMSUNG","GALAXY NOTE 10",650,null,null,null,"SM-2200","SAMSUNG","GALAXY NOTE 10",650]
[]
[null,"Brand Name","Criteria","Unit Price","Model",null,null,null,"Brand Name","Criteria","Unit Price","Model"]
[null,"APPLE","=",1000,{"$f":"IFERROR(INDEX($D$7:$D$14,SMALL(IF(($C$7:$C$14=$B$17)*\nIF($C$17=\">=\",($E$7:$E$14>=$D$17),IF($C$17=\">\",($E$7:$E$14>$D$17),\nIF($C$17=\"<=\",($E$7:$E$14<=$D$17),IF($C$17=\"=\",($E$7:$E$14=$D$17),\n($E$7:$E$14<$D$17))))),ROW($C$7:$C$14)),ROW(1:1))-6,1),\"\")","v":"IPHONE 14 PRO"},null,null,null,"APPLE","=",1000]
[null,null,null,null,{"$f":"IFERROR(INDEX($D$7:$D$14,SMALL(IF(($C$7:$C$14=$B$17)*\nIF($C$17=\">=\",($E$7:$E$14>=$D$17),IF($C$17=\">\",($E$7:$E$14>$D$17),\nIF($C$17=\"<=\",($E$7:$E$14<=$D$17),IF($C$17=\"=\",($E$7:$E$14=$D$17),\n($E$7:$E$14<$D$17))))),ROW($C$7:$C$14)),ROW(2:2))-6,1),\"\")","v":""}]
[null,null,null,null,{"$f":"IFERROR(INDEX($D$7:$D$14,SMALL(IF(($C$7:$C$14=$B$17)*\nIF($C$17=\">=\",($E$7:$E$14>=$D$17),IF($C$17=\">\",($E$7:$E$14>$D$17),\nIF($C$17=\"<=\",($E$7:$E$14<=$D$17),IF($C$17=\"=\",($E$7:$E$14=$D$17),\n($E$7:$E$14<$D$17))))),ROW($C$7:$C$14)),ROW(3:3))-6,1),\"\")","v":""}]
[null,null,null,null,{"$f":"IFERROR(INDEX($D$7:$D$14,SMALL(IF(($C$7:$C$14=$B$17)*\nIF($C$17=\">=\",($E$7:$E$14>=$D$17),IF($C$17=\">\",($E$7:$E$14>$D$17),\nIF($C$17=\"<=\",($E$7:$E$14<=$D$17),IF($C$17=\"=\",($E$7:$E$14=$D$17),\n($E$7:$E$14<$D$17))))),ROW($C$7:$C$14)),ROW(4:4))-6,1),\"\")","v":""}]
[null,null,null,null,{"$f":"IFERROR(INDEX($D$7:$D$14,SMALL(IF(($C$7:$C$14=$B$17)*IF($C$17=\">=\",($E$7:$E$14>=$D$17),IF($C$17=\">\",($E$7:$E$14>$D$17), IF($C$17=\"<=\",($E$7:$E$14<=$D$17),IF($C$17=\"=\",($E$7:$E$14=$D$17),($E$7:$E$14<$D$17))))),ROW($C$7:$C$14)),ROW(5:5))-6,1),\"\")","v":""}]
[null,null,null,null,{"$f":"IFERROR(INDEX($D$7:$D$14,SMALL(IF(($C$7:$C$14=$B$17)*IF($C$17=\">=\",($E$7:$E$14>=$D$17),IF($C$17=\">\",($E$7:$E$14>$D$17), IF($C$17=\"<=\",($E$7:$E$14<=$D$17),IF($C$17=\"=\",($E$7:$E$14=$D$17),($E$7:$E$14<$D$17))))),ROW($C$7:$C$14)),ROW(6:6))-6,1),\"\")","v":""}]
[null,null,null,null,{"$f":"IFERROR(INDEX($D$7:$D$14,SMALL(IF(($C$7:$C$14=$B$17)*IF($C$17=\">=\",($E$7:$E$14>=$D$17),IF($C$17=\">\",($E$7:$E$14>$D$17), IF($C$17=\"<=\",($E$7:$E$14<=$D$17),IF($C$17=\"=\",($E$7:$E$14=$D$17),($E$7:$E$14<$D$17))))),ROW($C$7:$C$14)),ROW(7:7))-6,1),\"\")","v":""}]
[]
[]
[null,null,null,null,null,{"$f":"IFERROR(INDEX($B$7:$E$14, SMALL(IF(COUNTIF($B$17:$B$20,$C$7:$C$14), MATCH(ROW($B$7:$E$14), ROW($B$7:$E$14)), \"\"), ROWS($C$19:F26)), COLUMNS($B$6:E13)),\"\")","v":""}]
[null,"Back to Home Page"]

{"sheet":"VLOOKUP","index":11,"n_rows":26,"n_cols":12,"rows_kept":26,"cut":false,"hidden":false,"merged":[[3,1,3,4],[1,1,1,4],[1,8,1,11],[3,8,3,11]]}
[]
[null,"Populating List Based on Cell Value",null,null,null,null,null,null,"Populating List Based on Cell Value"]
[]
[null,"Combining IFERROR, VLOOKUP and COLUMN Functions",null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Full Name","Department","Designation","Annual Salary",null,null,null,"Full Name","Department","Designation","Annual Salary"]
[null,"Marilyn Pittman","Executive","CEO",3000000,null,null,null,"Marilyn Pittman","Executive","CEO",3000000]
[null,"Samantha Carson","Sales","Manager",600000,null,null,null,"Samantha Carson","Sales","Manager",600000]
[null,"Clinton Webster","Sales","Associate",900000,null,null,null,"Clinton Webster","Sales","Associate",900000]
[null,"Chester Paul","Sales","Representative",100000,null,null,null,"Chester Paul","Sales","Representative",100000]
[null,"Rodney Gomez","Sales","Representative",100000,null,null,null,"Rodney Gomez","Sales","Representative",100000]
[null,"Jaime Schultz","Sales","Representative",100000,null,null,null,"Jaime Schultz","Sales","Representative",100000]
[null,"Abel Alvarado","Marketing","Manager",600000,null,null,null,"Abel Alvarado","Marketing","Manager",600000]
[null,"Rudy Palmer","Marketing","Coordinator",300000,null,null,null,"Rudy Palmer","Marketing","Coordinator",300000]
[]
[null,"Full Name","Rodney Gomez",null,null,null,{"$f":"IFERROR(INDEX($B$7:$D$14, SMALL(IF(COUNTIF($B$17:$B$19,$C$7:$C$14), MATCH(ROW($B$7:$D$14), ROW($B$7:$D$14)), \"\"), ROWS($C16:G$16)), COLUMNS($B$6:F6)),\"\")","v":""},null,"Full Name","Abel Alvarado"]
[]
[null,"Department","Designation","Annual Salary",null,null,null,null,"Department","Designation","Annual Salary"]
[null,{"$f":"IFERROR(VLOOKUP($C$16,$B$7:$E$14,COLUMN(B3),FALSE), \"\")","v":"Sales"},{"$f":"IFERROR(VLOOKUP($C$16,$B$7:$E$14,COLUMN(C3),FALSE), \"\")","v":"Representative"},100000,"",null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP($C$16,$B$7:$E$14,COLUMN(L3),FALSE), \"\")","v":""}]
[]
[null,null,null,null,{"$f":"IFERROR(INDEX($B$7:$D$14, SMALL(IF(COUNTIF($B$17:$B$19,$C$7:$C$14), MATCH(ROW($B$7:$D$14), ROW($B$7:$D$14)), \"\"), ROWS($C$16:E21)), COLUMNS($B$6:D11)),\"\")","v":""}]
[null,null,null,null,{"$f":"IFERROR(INDEX($B$7:$D$14, SMALL(IF(COUNTIF($B$17:$B$19,$C$7:$C$14), MATCH(ROW($B$7:$D$14), ROW($B$7:$D$14)), \"\"), ROWS($C$16:E22)), COLUMNS($B$6:D12)),\"\")","v":""}]
[null,null,null,null,{"$f":"IFERROR(INDEX($B$7:$D$14, SMALL(IF(COUNTIF($B$17:$B$19,$C$7:$C$14), MATCH(ROW($B$7:$D$14), ROW($B$7:$D$14)), \"\"), ROWS($C$16:E23)), COLUMNS($B$6:D13)),\"\")","v":""}]
[]
[]
[null,"Back to Home Page"]