{"text_format":"1","workbook":"xlsx","n_sheets":15,"sheets":["Dataset","LEFT","CONCATENATE","Number (Billion)","Number (Million)","Number (Thousand)","Number (Mixed)","Combine","Merge","Custom","TEXT","CHOOSE & WEEKDAY","VLOOKUP","XLOOKUP","INDEX & MATCH"],"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":"Dataset","index":0,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Sample Dataset"]
[]
[null,"Company","Revenue"]
[null,"Walmart Inc.",559200000000]
[null,"CVS Health Corporation",268700000000]
[null,"Exxon Mobil Corporation",181500000000]
[null,"Berkshire Hathaway Inc.",245500000000]
[null,"Apple Inc.",274500000000]
[null,"UnitedHealth Group Incorporated",257100000000]
[null,"McKesson Corporation",231000000000]

{"sheet":"LEFT","index":1,"n_rows":11,"n_cols":7,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,5,1,6]]}
[]
[null,"Using LEFT, MID, FIND & LEN Functions",null,null,null,">>>Practice Yourself<<<"]
[]
[null,"Company","Abbreviated Company Name (First Word)",null,null,"Company","Abbreviated Name"]
[null,"Walmart Inc.",{"$f":"LEFT(B5,1)&\". \"&MID(B5,FIND(\" \",B5)+1,LEN(B5))","v":"W. Inc."},null,null,"Walmart Inc."]
[null,"CVS Health Corporation",{"$f":"LEFT(B6,1)&\". \"&MID(B6,FIND(\" \",B6)+1,LEN(B6))","v":"C. Health Corporation"},null,null,"CVS Health Corporation"]
[null,"Exxon Mobil Corporation","E. Mobil Corporation",null,null,"Exxon Mobil Corporation"]
[null,"Berkshire Hathaway Inc.","B. Hathaway Inc.",null,null,"Berkshire Hathaway Inc."]
[null,"Apple Inc.","A. Inc.",null,null,"Apple Inc."]
[null,"UnitedHealth Group Incorporated","U. Group Incorporated",null,null,"UnitedHealth Group Incorporated"]
[null,"McKesson Corporation","M. Corporation",null,null,"McKesson Corporation"]

{"sheet":"CONCATENATE","index":2,"n_rows":11,"n_cols":7,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,5,1,6]]}
[]
[null,"Using CONCATENATE, LEFT, MID, FIND & LEN Functions",null,null,null,">>>Practice Yourself<<<"]
[]
[null,"Company","Abbreviated Company Name (First Word)",null,null,"Company","Abbreviated Name"]
[null,"Walmart Inc.",{"$f":"CONCATENATE(LEFT(B5,1),\". \",MID(B5,FIND(\" \",B5)+1,LEN(B5)))","v":"W. Inc."},null,null,"Walmart Inc."]
[null,"CVS Health Corporation",{"$f":"CONCATENATE(LEFT(B6,1),\". \",MID(B6,FIND(\" \",B6)+1,LEN(B6)))","v":"C. Health Corporation"},null,null,"CVS Health Corporation"]
[null,"Exxon Mobil Corporation","E. Mobil Corporation",null,null,"Exxon Mobil Corporation"]
[null,"Berkshire Hathaway Inc.","B. Hathaway Inc.",null,null,"Berkshire Hathaway Inc."]
[null,"Apple Inc.","A. Inc.",null,null,"Apple Inc."]
[null,"UnitedHealth Group Incorporated","U. Group Incorporated",null,null,"UnitedHealth Group Incorporated"]
[null,"McKesson Corporation","M. Corporation",null,null,"McKesson Corporation"]

{"sheet":"Number (Billion)","index":3,"n_rows":11,"n_cols":7,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,5,1,6]]}
[]
[null,"Abbreviating Numbers (in Billions)",null,null,null,">>>Practice Yourself<<<"]
[]
[null,"Company","Revenue","Abbreviated Revenue (Billion)",null,"Revenue","Abbreviated Revenue (Billion)"]
[null,"Walmart Inc.",559200000000,559200000000,null,559200000000]
[null,"CVS Health Corporation",268700000000,268700000000,null,268700000000]
[null,"Exxon Mobil Corporation",181500000000,181500000000,null,181500000000]
[null,"Berkshire Hathaway Inc.",245500000000,245500000000,null,245500000000]
[null,"Apple Inc.",274500000000,274500000000,null,274500000000]
[null,"UnitedHealth Group",257100000000,257100000000,null,257100000000]
[null,"McKesson Corporation",231000000000,231000000000,null,231000000000]

{"sheet":"Number (Million)","index":4,"n_rows":11,"n_cols":7,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,5,1,6]]}
[]
[null,"Abbreviating Numbers (in Millions)",null,null,null,">>>Practice Yourself<<<"]
[]
[null,"Company","Salary of CEO (Yearly)","Abbreviated Salary (Million)",null,"Salary of CEO (Yearly)","Abbreviated Salary (Million)"]
[null,"Walmart Inc.",1300000,1300000,null,1300000]
[null,"CVS Health Corporation",1400000,1400000,null,1400000]
[null,"Exxon Mobil Corporation",1200000,1200000,null,1200000]
[null,"Berkshire Hathaway Inc.",100000,100000,null,100000]
[null,"Apple Inc.",3000000,3000000,null,3000000]
[null,"UnitedHealth Group",1300000,1300000,null,1300000]
[null,"McKesson Corporation",1200000,1200000,null,1200000]

{"sheet":"Number (Thousand)","index":5,"n_rows":11,"n_cols":7,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,5,1,6]]}
[]
[null,"Abbreviating Numbers (in Thousands)",null,null,null,">>>Practice Yourself<<<"]
[]
[null,"Company","Workforce","Abbreviated Workforce (Thousand)",null,"Workforce","Abbreviated Workforce (Thousand)"]
[null,"Walmart Inc.",2300000,2300000,null,2300000]
[null,"CVS Health Corporation",300000,300000,null,300000]
[null,"Exxon Mobil Corporation",72000,72000,null,72000]
[null,"Berkshire Hathaway Inc.",100000,100000,null,100000]
[null,"Apple Inc.",147000,147000,null,147000]
[null,"UnitedHealth Group",400000,400000,null,400000]
[null,"McKesson Corporation",80000,80000,null,80000]

{"sheet":"Number (Mixed)","index":6,"n_rows":25,"n_cols":10,"rows_kept":25,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,6,1,9],[4,6,6,6],[7,6,9,6],[10,6,12,6],[4,1,6,1],[7,1,9,1],[10,1,12,1],[16,6,18,6],[19,6,21,6],[22,6,24,6],[13,1,15,1],[16,1,18,1],[19,1,21,1],[22,1,24,1],[13,6,15,6]]}
[]
[null,"Abbreviating Numbers Differently Based on Value",null,null,null,null,">>>Practice Yourself<<<"]
[]
[null,"Company","Parameters","Without Abbreviation","With Abbreviation",null,"Company","Parameters","Without Abbreviation","With Abbreviation"]
[null,"Walmart Inc.","Revenue",559200000000,559200000000,null,"Walmart Inc.","Revenue",559200000000]
[null,null,"Yearly Salary of CEO",1300000,1300000,null,null,"Yearly Salary of CEO",1300000]
[null,null,"Workforce",2300000,2300000,null,null,"Workforce",2300000]
[null,"CVS Health Corporation","Revenue",268700000000,268700000000,null,"CVS Health Corporation","Revenue",268700000000]
[null,null,"Yearly Salary of CEO",1400000,1400000,null,null,"Yearly Salary of CEO",1400000]
[null,null,"Workforce",300000,300000,null,null,"Workforce",300000]
[null,"Exxon Mobil Corporation","Revenue",181500000000,181500000000,null,"Exxon Mobil Corporation","Revenue",181500000000]
[null,null,"Yearly Salary of CEO",1200000,1200000,null,null,"Yearly Salary of CEO",1200000]
[null,null,"Workforce",72000,72000,null,null,"Workforce",72000]
[null,"Berkshire Hathaway Inc.","Revenue",245500000000,245500000000,null,"Berkshire Hathaway Inc.","Revenue",245500000000]
[null,null,"Yearly Salary of CEO",100000,100000,null,null,"Yearly Salary of CEO",100000]
[null,null,"Workforce",100000,100000,null,null,"Workforce",100000]
[null,"Apple Inc.","Revenue",274500000000,274500000000,null,"Apple Inc.","Revenue",274500000000]
[null,null,"Yearly Salary of CEO",3000000,3000000,null,null,"Yearly Salary of CEO",3000000]
[null,null,"Workforce",147000,147000,null,null,"Workforce",147000]
[null,"UnitedHealth Group","Revenue",257100000000,257100000000,null,"UnitedHealth Group","Revenue",257100000000]
[null,null,"Yearly Salary of CEO",1300000,1300000,null,null,"Yearly Salary of CEO",1300000]
[null,null,"Workforce",400000,400000,null,null,"Workforce",400000]
[null,"McKesson Corporation","Revenue",231000000000,231000000000,null,"McKesson Corporation","Revenue",231000000000]
[null,null,"Yearly Salary of CEO",1200000,1200000,null,null,"Yearly Salary of CEO",1200000]
[null,null,"Workforce",80000,80000,null,null,"Workforce",80000]

{"sheet":"Combine","index":7,"n_rows":11,"n_cols":7,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,5,1,6]]}
[]
[null,"Combining Multiple Functions",null,null,null,">>>Practice Yourself<<<"]
[]
[null,"Company","Abbreviated Name",null,null,"Company","Abbreviated Name"]
[null,"Walmart Inc.",{"$f":"_xlfn.TEXTJOIN(\"\",1,IF(ISNUMBER(MATCH(CODE(MID(B5,\nROW(INDIRECT(\"1:\"&LEN(B5))),1)),\nROW(INDIRECT(\"63:90\")),0)),\nMID(B5,ROW(INDIRECT(\"1:\"&LEN(B5))),1),\"\"))","v":"WI"},null,null,"Walmart Inc."]
[null,"CVS Health Corporation",{"$f":"_xlfn.TEXTJOIN(\"\",1,IF(ISNUMBER(MATCH(CODE(MID(B6,\nROW(INDIRECT(\"1:\"&LEN(B6))),1)),\nROW(INDIRECT(\"63:90\")),0)),\nMID(B6,ROW(INDIRECT(\"1:\"&LEN(B6))),1),\"\"))","v":"CVSHC"},null,null,"CVS Health Corporation"]
[null,"Exxon Mobil Corporation",{"$f":"_xlfn.TEXTJOIN(\"\",1,IF(ISNUMBER(MATCH(CODE(MID(B7,\nROW(INDIRECT(\"1:\"&LEN(B7))),1)),\nROW(INDIRECT(\"63:90\")),0)),\nMID(B7,ROW(INDIRECT(\"1:\"&LEN(B7))),1),\"\"))","v":"EMC"},null,null,"Exxon Mobil Corporation"]
[null,"Berkshire Hathaway Inc.",{"$f":"_xlfn.TEXTJOIN(\"\",1,IF(ISNUMBER(MATCH(CODE(MID(B8,\nROW(INDIRECT(\"1:\"&LEN(B8))),1)),\nROW(INDIRECT(\"63:90\")),0)),\nMID(B8,ROW(INDIRECT(\"1:\"&LEN(B8))),1),\"\"))","v":"BHI"},null,null,"Berkshire Hathaway Inc."]
[null,"Apple Inc.",{"$f":"_xlfn.TEXTJOIN(\"\",1,IF(ISNUMBER(MATCH(CODE(MID(B9,\nROW(INDIRECT(\"1:\"&LEN(B9))),1)),\nROW(INDIRECT(\"63:90\")),0)),\nMID(B9,ROW(INDIRECT(\"1:\"&LEN(B9))),1),\"\"))","v":"AI"},null,null,"Apple Inc."]
[null,"UnitedHealth Group Incorporated",{"$f":"_xlfn.TEXTJOIN(\"\",1,IF(ISNUMBER(MATCH(CODE(MID(B10,\nROW(INDIRECT(\"1:\"&LEN(B10))),1)),\nROW(INDIRECT(\"63:90\")),0)),\nMID(B10,ROW(INDIRECT(\"1:\"&LEN(B10))),1),\"\"))","v":"UHGI"},null,null,"UnitedHealth Group Incorporated"]
[null,"McKesson Corporation",{"$f":"_xlfn.TEXTJOIN(\"\",1,IF(ISNUMBER(MATCH(CODE(MID(B11,\nROW(INDIRECT(\"1:\"&LEN(B11))),1)),\nROW(INDIRECT(\"63:90\")),0)),\nMID(B11,ROW(INDIRECT(\"1:\"&LEN(B11))),1),\"\"))","v":"MKC"},null,null,"McKesson Corporation"]

{"sheet":"Merge","index":8,"n_rows":11,"n_cols":7,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,5,1,6]]}
[]
[null,"Merging Multiple Functions",null,null,null,">>>Practice Yourself<<<"]
[]
[null,"Company","Abbreviated Name",null,null,"Company","Abbreviated Name"]
[null,"Walmart Inc.",{"$f":"UPPER(TRIM(LEFT(B5,1)&MID(B5,FIND(\" \",B5&\" \")+1,1)&\nMID(B5,FIND(\"*\",SUBSTITUTE(B5&\" \",\" \",\"*\",2))+1,1)))","v":"WI"},null,null,"Walmart Inc."]
[null,"CVS Health Corporation",{"$f":"UPPER(TRIM(LEFT(B6,1)&MID(B6,FIND(\" \",B6&\" \")+1,1)&\nMID(B6,FIND(\"*\",SUBSTITUTE(B6&\" \",\" \",\"*\",2))+1,1)))","v":"CHC"},null,null,"CVS Health Corporation"]
[null,"Exxon Mobil Corporation","EMC",null,null,"Exxon Mobil Corporation"]
[null,"Berkshire Hathaway Inc.","BHI",null,null,"Berkshire Hathaway Inc."]
[null,"Apple Inc.","AI",null,null,"Apple Inc."]
[null,"UnitedHealth Group Incorporated","UGI",null,null,"UnitedHealth Group Incorporated"]
[null,"McKesson Corporation","MC",null,null,"McKesson Corporation"]

{"sheet":"Custom","index":9,"n_rows":11,"n_cols":7,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,5,1,6]]}
[]
[null,"Use of Custom Function from VBA Code",null,null,null,">>>Practice Yourself<<<"]
[]
[null,"Company","Abbreviated Name",null,null,"Company","Abbreviated Name"]
[null,"Walmart Inc.",{"$f":"AbbreviateString(B5)","v":"WI"},null,null,"Walmart Inc."]
[null,"CVS Health Corporation",{"$f":"AbbreviateString(B6)","v":"CHC"},null,null,"CVS Health Corporation"]
[null,"Exxon Mobil Corporation",{"$f":"AbbreviateString(B7)","v":"EMC"},null,null,"Exxon Mobil Corporation"]
[null,"Berkshire Hathaway Inc.",{"$f":"AbbreviateString(B8)","v":"BHI"},null,null,"Berkshire Hathaway Inc."]
[null,"Apple Inc.",{"$f":"AbbreviateString(B9)","v":"AI"},null,null,"Apple Inc."]
[null,"UnitedHealth Group Incorporated",{"$f":"AbbreviateString(B10)","v":"UGI"},null,null,"UnitedHealth Group Incorporated"]
[null,"McKesson Corporation",{"$f":"AbbreviateString(B11)","v":"MC"},null,null,"McKesson Corporation"]

{"sheet":"TEXT","index":10,"n_rows":11,"n_cols":12,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,8,1,11]]}
[]
[null,"Abbreviating Days Using TEXT Function",null,null,null,null,null,null,">>>Practice Yourself<<<"]
[]
[null,"Company","Revenue","Founding Dates","Day",null,null,null,"Company","Revenue","Founding Dates","Day"]
[null,"Walmart Inc.",559200000000,"1962-07-02",{"$f":"TEXT(D5, \"ddd\")","v":"Mon"},null,null,null,"Walmart Inc.",559200000000,"1962-07-02"]
[null,"CVS Health Corporation",268700000000,"1963-04-01",{"$f":"TEXT(D6, \"ddd\")","v":"Mon"},null,null,null,"CVS Health Corporation",268700000000,"1963-04-01"]
[null,"Exxon Mobil Corporation",181500000000,"1999-11-30","Tue",null,null,null,"Exxon Mobil Corporation",181500000000,"1999-11-30"]
[null,"Berkshire Hathaway Inc.",245500000000,"1939-05-10","Wed",null,null,null,"Berkshire Hathaway Inc.",245500000000,"1939-05-10"]
[null,"Apple Inc.",274500000000,"1976-04-01","Thu",null,null,null,"Apple Inc.",274500000000,"1976-04-01"]
[null,"UnitedHealth Group Incorporated",257100000000,"1977-06-05","Sun",null,null,null,"UnitedHealth Group Incorporated",257100000000,"1977-06-05"]
[null,"McKesson Corporation",231000000000,"1933-08-12","Sat",null,null,null,"McKesson Corporation",231000000000,"1933-08-12"]

{"sheet":"CHOOSE & WEEKDAY","index":11,"n_rows":11,"n_cols":12,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,8,1,11]]}
[]
[null,"Abbreviating Days Using CHOOSE & WEEKDAY Functions",null,null,null,null,null,null,">>>Practice Yourself<<<"]
[]
[null,"Company","Revenue","Founding Dates","Day",null,null,null,"Company","Revenue","Founding Dates","Day"]
[null,"Walmart Inc.",559200000000,"1962-07-02",{"$f":"CHOOSE(WEEKDAY(D5),\"Sun\",\"Mon\",\"Tue\",\"Wed\",\"Thu\",\"Fri\",\"Sat\")","v":"Mon"},null,null,null,"Walmart Inc.",559200000000,"1962-07-02"]
[null,"CVS Health Corporation",268700000000,"1963-04-01",{"$f":"CHOOSE(WEEKDAY(D6),\"Sun\",\"Mon\",\"Tue\",\"Wed\",\"Thu\",\"Fri\",\"Sat\")","v":"Mon"},null,null,null,"CVS Health Corporation",268700000000,"1963-04-01"]
[null,"Exxon Mobil Corporation",181500000000,"1999-11-30","Tue",null,null,null,"Exxon Mobil Corporation",181500000000,"1999-11-30"]
[null,"Berkshire Hathaway Inc.",245500000000,"1939-05-10","Wed",null,null,null,"Berkshire Hathaway Inc.",245500000000,"1939-05-10"]
[null,"Apple Inc.",274500000000,"1976-04-01","Thu",null,null,null,"Apple Inc.",274500000000,"1976-04-01"]
[null,"UnitedHealth Group Incorporated",257100000000,"1977-06-05","Sun",null,null,null,"UnitedHealth Group Incorporated",257100000000,"1977-06-05"]
[null,"McKesson Corporation",231000000000,"1933-08-12","Sat",null,null,null,"McKesson Corporation",231000000000,"1933-08-12"]

{"sheet":"VLOOKUP","index":12,"n_rows":14,"n_cols":7,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,5,1,6]]}
[]
[null,"Finding Abbreviations Using VLOOKUP Function",null,null,null,">>>Practice Yourself<<<"]
[]
[null,"Company","Abbreviated Name",null,null,"Company","Abbreviated Name"]
[null,"Walmart Inc.",{"$f":"_xlfn.TEXTJOIN(\"\",1,IF(ISNUMBER(MATCH(CODE(MID(B5,\nROW(INDIRECT(\"1:\"&LEN(B5))),1)),\nROW(INDIRECT(\"63:90\")),0)),\nMID(B5,ROW(INDIRECT(\"1:\"&LEN(B5))),1),\"\"))","v":"WI"},null,null,"Walmart Inc.",{"$f":"_xlfn.TEXTJOIN(\"\",1,IF(ISNUMBER(MATCH(CODE(MID(F5,\nROW(INDIRECT(\"1:\"&LEN(F5))),1)),\nROW(INDIRECT(\"63:90\")),0)),\nMID(F5,ROW(INDIRECT(\"1:\"&LEN(F5))),1),\"\"))","v":"WI"}]
[null,"CVS Health Corporation",{"$f":"_xlfn.TEXTJOIN(\"\",1,IF(ISNUMBER(MATCH(CODE(MID(B6,\nROW(INDIRECT(\"1:\"&LEN(B6))),1)),\nROW(INDIRECT(\"63:90\")),0)),\nMID(B6,ROW(INDIRECT(\"1:\"&LEN(B6))),1),\"\"))","v":"CVSHC"},null,null,"CVS Health Corporation",{"$f":"_xlfn.TEXTJOIN(\"\",1,IF(ISNUMBER(MATCH(CODE(MID(F6,\nROW(INDIRECT(\"1:\"&LEN(F6))),1)),\nROW(INDIRECT(\"63:90\")),0)),\nMID(F6,ROW(INDIRECT(\"1:\"&LEN(F6))),1),\"\"))","v":"CVSHC"}]
[null,"Exxon Mobil Corporation",{"$f":"_xlfn.TEXTJOIN(\"\",1,IF(ISNUMBER(MATCH(CODE(MID(B7,\nROW(INDIRECT(\"1:\"&LEN(B7))),1)),\nROW(INDIRECT(\"63:90\")),0)),\nMID(B7,ROW(INDIRECT(\"1:\"&LEN(B7))),1),\"\"))","v":"EMC"},null,null,"Exxon Mobil Corporation",{"$f":"_xlfn.TEXTJOIN(\"\",1,IF(ISNUMBER(MATCH(CODE(MID(F7,\nROW(INDIRECT(\"1:\"&LEN(F7))),1)),\nROW(INDIRECT(\"63:90\")),0)),\nMID(F7,ROW(INDIRECT(\"1:\"&LEN(F7))),1),\"\"))","v":"EMC"}]
[null,"Berkshire Hathaway Inc.",{"$f":"_xlfn.TEXTJOIN(\"\",1,IF(ISNUMBER(MATCH(CODE(MID(B8,\nROW(INDIRECT(\"1:\"&LEN(B8))),1)),\nROW(INDIRECT(\"63:90\")),0)),\nMID(B8,ROW(INDIRECT(\"1:\"&LEN(B8))),1),\"\"))","v":"BHI"},null,null,"Berkshire Hathaway Inc.",{"$f":"_xlfn.TEXTJOIN(\"\",1,IF(ISNUMBER(MATCH(CODE(MID(F8,\nROW(INDIRECT(\"1:\"&LEN(F8))),1)),\nROW(INDIRECT(\"63:90\")),0)),\nMID(F8,ROW(INDIRECT(\"1:\"&LEN(F8))),1),\"\"))","v":"BHI"}]
[null,"Apple Inc.",{"$f":"_xlfn.TEXTJOIN(\"\",1,IF(ISNUMBER(MATCH(CODE(MID(B9,\nROW(INDIRECT(\"1:\"&LEN(B9))),1)),\nROW(INDIRECT(\"63:90\")),0)),\nMID(B9,ROW(INDIRECT(\"1:\"&LEN(B9))),1),\"\"))","v":"AI"},null,null,"Apple Inc.",{"$f":"_xlfn.TEXTJOIN(\"\",1,IF(ISNUMBER(MATCH(CODE(MID(F9,\nROW(INDIRECT(\"1:\"&LEN(F9))),1)),\nROW(INDIRECT(\"63:90\")),0)),\nMID(F9,ROW(INDIRECT(\"1:\"&LEN(F9))),1),\"\"))","v":"AI"}]
[null,"UnitedHealth Group Incorporated",{"$f":"_xlfn.TEXTJOIN(\"\",1,IF(ISNUMBER(MATCH(CODE(MID(B10,\nROW(INDIRECT(\"1:\"&LEN(B10))),1)),\nROW(INDIRECT(\"63:90\")),0)),\nMID(B10,ROW(INDIRECT(\"1:\"&LEN(B10))),1),\"\"))","v":"UHGI"},null,null,"UnitedHealth Group Incorporated",{"$f":"_xlfn.TEXTJOIN(\"\",1,IF(ISNUMBER(MATCH(CODE(MID(F10,\nROW(INDIRECT(\"1:\"&LEN(F10))),1)),\nROW(INDIRECT(\"63:90\")),0)),\nMID(F10,ROW(INDIRECT(\"1:\"&LEN(F10))),1),\"\"))","v":"UHGI"}]
[null,"McKesson Corporation",{"$f":"_xlfn.TEXTJOIN(\"\",1,IF(ISNUMBER(MATCH(CODE(MID(B11,\nROW(INDIRECT(\"1:\"&LEN(B11))),1)),\nROW(INDIRECT(\"63:90\")),0)),\nMID(B11,ROW(INDIRECT(\"1:\"&LEN(B11))),1),\"\"))","v":"MKC"},null,null,"McKesson Corporation",{"$f":"_xlfn.TEXTJOIN(\"\",1,IF(ISNUMBER(MATCH(CODE(MID(F11,\nROW(INDIRECT(\"1:\"&LEN(F11))),1)),\nROW(INDIRECT(\"63:90\")),0)),\nMID(F11,ROW(INDIRECT(\"1:\"&LEN(F11))),1),\"\"))","v":"MKC"}]
[]
[null,"Company Full Name","Abbreviated Name",null,null,"Company Full Name","Abbreviated Name"]
[null,"Apple Inc.",{"$f":"VLOOKUP(B14,B4:C11,2,FALSE)","v":"AI"},null,null,"UnitedHealth Group Incorporated"]

{"sheet":"XLOOKUP","index":13,"n_rows":14,"n_cols":7,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,5,1,6]]}
[]
[null,"Finding Abbreviations Using XLOOKUP Function",null,null,null,">>>Practice Yourself<<<"]
[]
[null,"Company","Abbreviated Name",null,null,"Company","Abbreviated Name"]
[null,"Walmart Inc.",{"$f":"_xlfn.TEXTJOIN(\"\",1,IF(ISNUMBER(MATCH(CODE(MID(B5,\nROW(INDIRECT(\"1:\"&LEN(B5))),1)),\nROW(INDIRECT(\"63:90\")),0)),\nMID(B5,ROW(INDIRECT(\"1:\"&LEN(B5))),1),\"\"))","v":"WI"},null,null,"Walmart Inc.",{"$f":"_xlfn.TEXTJOIN(\"\",1,IF(ISNUMBER(MATCH(CODE(MID(F5,\nROW(INDIRECT(\"1:\"&LEN(F5))),1)),\nROW(INDIRECT(\"63:90\")),0)),\nMID(F5,ROW(INDIRECT(\"1:\"&LEN(F5))),1),\"\"))","v":"WI"}]
[null,"CVS Health Corporation",{"$f":"_xlfn.TEXTJOIN(\"\",1,IF(ISNUMBER(MATCH(CODE(MID(B6,\nROW(INDIRECT(\"1:\"&LEN(B6))),1)),\nROW(INDIRECT(\"63:90\")),0)),\nMID(B6,ROW(INDIRECT(\"1:\"&LEN(B6))),1),\"\"))","v":"CVSHC"},null,null,"CVS Health Corporation",{"$f":"_xlfn.TEXTJOIN(\"\",1,IF(ISNUMBER(MATCH(CODE(MID(F6,\nROW(INDIRECT(\"1:\"&LEN(F6))),1)),\nROW(INDIRECT(\"63:90\")),0)),\nMID(F6,ROW(INDIRECT(\"1:\"&LEN(F6))),1),\"\"))","v":"CVSHC"}]
[null,"Exxon Mobil Corporation",{"$f":"_xlfn.TEXTJOIN(\"\",1,IF(ISNUMBER(MATCH(CODE(MID(B7,\nROW(INDIRECT(\"1:\"&LEN(B7))),1)),\nROW(INDIRECT(\"63:90\")),0)),\nMID(B7,ROW(INDIRECT(\"1:\"&LEN(B7))),1),\"\"))","v":"EMC"},null,null,"Exxon Mobil Corporation",{"$f":"_xlfn.TEXTJOIN(\"\",1,IF(ISNUMBER(MATCH(CODE(MID(F7,\nROW(INDIRECT(\"1:\"&LEN(F7))),1)),\nROW(INDIRECT(\"63:90\")),0)),\nMID(F7,ROW(INDIRECT(\"1:\"&LEN(F7))),1),\"\"))","v":"EMC"}]
[null,"Berkshire Hathaway Inc.",{"$f":"_xlfn.TEXTJOIN(\"\",1,IF(ISNUMBER(MATCH(CODE(MID(B8,\nROW(INDIRECT(\"1:\"&LEN(B8))),1)),\nROW(INDIRECT(\"63:90\")),0)),\nMID(B8,ROW(INDIRECT(\"1:\"&LEN(B8))),1),\"\"))","v":"BHI"},null,null,"Berkshire Hathaway Inc.",{"$f":"_xlfn.TEXTJOIN(\"\",1,IF(ISNUMBER(MATCH(CODE(MID(F8,\nROW(INDIRECT(\"1:\"&LEN(F8))),1)),\nROW(INDIRECT(\"63:90\")),0)),\nMID(F8,ROW(INDIRECT(\"1:\"&LEN(F8))),1),\"\"))","v":"BHI"}]
[null,"Apple Inc.",{"$f":"_xlfn.TEXTJOIN(\"\",1,IF(ISNUMBER(MATCH(CODE(MID(B9,\nROW(INDIRECT(\"1:\"&LEN(B9))),1)),\nROW(INDIRECT(\"63:90\")),0)),\nMID(B9,ROW(INDIRECT(\"1:\"&LEN(B9))),1),\"\"))","v":"AI"},null,null,"Apple Inc.",{"$f":"_xlfn.TEXTJOIN(\"\",1,IF(ISNUMBER(MATCH(CODE(MID(F9,\nROW(INDIRECT(\"1:\"&LEN(F9))),1)),\nROW(INDIRECT(\"63:90\")),0)),\nMID(F9,ROW(INDIRECT(\"1:\"&LEN(F9))),1),\"\"))","v":"AI"}]
[null,"UnitedHealth Group Incorporated",{"$f":"_xlfn.TEXTJOIN(\"\",1,IF(ISNUMBER(MATCH(CODE(MID(B10,\nROW(INDIRECT(\"1:\"&LEN(B10))),1)),\nROW(INDIRECT(\"63:90\")),0)),\nMID(B10,ROW(INDIRECT(\"1:\"&LEN(B10))),1),\"\"))","v":"UHGI"},null,null,"UnitedHealth Group Incorporated",{"$f":"_xlfn.TEXTJOIN(\"\",1,IF(ISNUMBER(MATCH(CODE(MID(F10,\nROW(INDIRECT(\"1:\"&LEN(F10))),1)),\nROW(INDIRECT(\"63:90\")),0)),\nMID(F10,ROW(INDIRECT(\"1:\"&LEN(F10))),1),\"\"))","v":"UHGI"}]
[null,"McKesson Corporation",{"$f":"_xlfn.TEXTJOIN(\"\",1,IF(ISNUMBER(MATCH(CODE(MID(B11,\nROW(INDIRECT(\"1:\"&LEN(B11))),1)),\nROW(INDIRECT(\"63:90\")),0)),\nMID(B11,ROW(INDIRECT(\"1:\"&LEN(B11))),1),\"\"))","v":"MKC"},null,null,"McKesson Corporation",{"$f":"_xlfn.TEXTJOIN(\"\",1,IF(ISNUMBER(MATCH(CODE(MID(F11,\nROW(INDIRECT(\"1:\"&LEN(F11))),1)),\nROW(INDIRECT(\"63:90\")),0)),\nMID(F11,ROW(INDIRECT(\"1:\"&LEN(F11))),1),\"\"))","v":"MKC"}]
[]
[null,"Company Full Name","Abbreviated Name",null,null,"Company Full Name","Abbreviated Name"]
[null,"McKesson Corporation",{"$f":"_xlfn.XLOOKUP(B14,B5:B11,C5:C11,\"Not Available\",0,)","v":"MKC"},null,null,"UnitedHealth Group Incorporated"]

{"sheet":"INDEX & MATCH","index":14,"n_rows":14,"n_cols":7,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,5,1,6]]}
[]
[null,"Finding Abbreviations Combining INDEX & MATCH Functions",null,null,null,">>>Practice Yourself<<<"]
[]
[null,"Company","Abbreviated Name",null,null,"Company","Abbreviated Name"]
[null,"Walmart Inc.",{"$f":"_xlfn.TEXTJOIN(\"\",1,IF(ISNUMBER(MATCH(CODE(MID(B5,\nROW(INDIRECT(\"1:\"&LEN(B5))),1)),\nROW(INDIRECT(\"63:90\")),0)),\nMID(B5,ROW(INDIRECT(\"1:\"&LEN(B5))),1),\"\"))","v":"WI"},null,null,"Walmart Inc.",{"$f":"_xlfn.TEXTJOIN(\"\",1,IF(ISNUMBER(MATCH(CODE(MID(F5,\nROW(INDIRECT(\"1:\"&LEN(F5))),1)),\nROW(INDIRECT(\"63:90\")),0)),\nMID(F5,ROW(INDIRECT(\"1:\"&LEN(F5))),1),\"\"))","v":"WI"}]
[null,"CVS Health Corporation",{"$f":"_xlfn.TEXTJOIN(\"\",1,IF(ISNUMBER(MATCH(CODE(MID(B6,\nROW(INDIRECT(\"1:\"&LEN(B6))),1)),\nROW(INDIRECT(\"63:90\")),0)),\nMID(B6,ROW(INDIRECT(\"1:\"&LEN(B6))),1),\"\"))","v":"CVSHC"},null,null,"CVS Health Corporation",{"$f":"_xlfn.TEXTJOIN(\"\",1,IF(ISNUMBER(MATCH(CODE(MID(F6,\nROW(INDIRECT(\"1:\"&LEN(F6))),1)),\nROW(INDIRECT(\"63:90\")),0)),\nMID(F6,ROW(INDIRECT(\"1:\"&LEN(F6))),1),\"\"))","v":"CVSHC"}]
[null,"Exxon Mobil Corporation",{"$f":"_xlfn.TEXTJOIN(\"\",1,IF(ISNUMBER(MATCH(CODE(MID(B7,\nROW(INDIRECT(\"1:\"&LEN(B7))),1)),\nROW(INDIRECT(\"63:90\")),0)),\nMID(B7,ROW(INDIRECT(\"1:\"&LEN(B7))),1),\"\"))","v":"EMC"},null,null,"Exxon Mobil Corporation",{"$f":"_xlfn.TEXTJOIN(\"\",1,IF(ISNUMBER(MATCH(CODE(MID(F7,\nROW(INDIRECT(\"1:\"&LEN(F7))),1)),\nROW(INDIRECT(\"63:90\")),0)),\nMID(F7,ROW(INDIRECT(\"1:\"&LEN(F7))),1),\"\"))","v":"EMC"}]
[null,"Berkshire Hathaway Inc.",{"$f":"_xlfn.TEXTJOIN(\"\",1,IF(ISNUMBER(MATCH(CODE(MID(B8,\nROW(INDIRECT(\"1:\"&LEN(B8))),1)),\nROW(INDIRECT(\"63:90\")),0)),\nMID(B8,ROW(INDIRECT(\"1:\"&LEN(B8))),1),\"\"))","v":"BHI"},null,null,"Berkshire Hathaway Inc.",{"$f":"_xlfn.TEXTJOIN(\"\",1,IF(ISNUMBER(MATCH(CODE(MID(F8,\nROW(INDIRECT(\"1:\"&LEN(F8))),1)),\nROW(INDIRECT(\"63:90\")),0)),\nMID(F8,ROW(INDIRECT(\"1:\"&LEN(F8))),1),\"\"))","v":"BHI"}]
[null,"Apple Inc.",{"$f":"_xlfn.TEXTJOIN(\"\",1,IF(ISNUMBER(MATCH(CODE(MID(B9,\nROW(INDIRECT(\"1:\"&LEN(B9))),1)),\nROW(INDIRECT(\"63:90\")),0)),\nMID(B9,ROW(INDIRECT(\"1:\"&LEN(B9))),1),\"\"))","v":"AI"},null,null,"Apple Inc.",{"$f":"_xlfn.TEXTJOIN(\"\",1,IF(ISNUMBER(MATCH(CODE(MID(F9,\nROW(INDIRECT(\"1:\"&LEN(F9))),1)),\nROW(INDIRECT(\"63:90\")),0)),\nMID(F9,ROW(INDIRECT(\"1:\"&LEN(F9))),1),\"\"))","v":"AI"}]
[null,"UnitedHealth Group Incorporated",{"$f":"_xlfn.TEXTJOIN(\"\",1,IF(ISNUMBER(MATCH(CODE(MID(B10,\nROW(INDIRECT(\"1:\"&LEN(B10))),1)),\nROW(INDIRECT(\"63:90\")),0)),\nMID(B10,ROW(INDIRECT(\"1:\"&LEN(B10))),1),\"\"))","v":"UHGI"},null,null,"UnitedHealth Group Incorporated",{"$f":"_xlfn.TEXTJOIN(\"\",1,IF(ISNUMBER(MATCH(CODE(MID(F10,\nROW(INDIRECT(\"1:\"&LEN(F10))),1)),\nROW(INDIRECT(\"63:90\")),0)),\nMID(F10,ROW(INDIRECT(\"1:\"&LEN(F10))),1),\"\"))","v":"UHGI"}]
[null,"McKesson Corporation",{"$f":"_xlfn.TEXTJOIN(\"\",1,IF(ISNUMBER(MATCH(CODE(MID(B11,\nROW(INDIRECT(\"1:\"&LEN(B11))),1)),\nROW(INDIRECT(\"63:90\")),0)),\nMID(B11,ROW(INDIRECT(\"1:\"&LEN(B11))),1),\"\"))","v":"MKC"},null,null,"McKesson Corporation",{"$f":"_xlfn.TEXTJOIN(\"\",1,IF(ISNUMBER(MATCH(CODE(MID(F11,\nROW(INDIRECT(\"1:\"&LEN(F11))),1)),\nROW(INDIRECT(\"63:90\")),0)),\nMID(F11,ROW(INDIRECT(\"1:\"&LEN(F11))),1),\"\"))","v":"MKC"}]
[]
[null,"Company Full Name","Abbreviated Name",null,null,"Company Full Name","Abbreviated Name"]
[null,"Berkshire Hathaway Inc.",{"$f":"INDEX(C5:C11,MATCH(B14,B5:B11,0),)","v":"BHI"},null,null,"UnitedHealth Group Incorporated"]