{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["A"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":48,"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":"A","index":0,"n_rows":32,"n_cols":13,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
[null,null,"VLOOKUP TABLE",null,null,null,{"$f":"NOW()","v":"2025-10-05T10:24:05.440"},{"$f":"getformula(G1)","v":"<--  =NOW()"}]
["30 Dow Jones Industrials","Ticker","Price","Change","% Change","Volume","YTD Chg","Rating"]
["MMM 3M",{"$f":"LEFT(A3,SEARCH(\" \",A3)-1)","v":"MMM"},243.88,-0.26,-1.0649627263045794E-3,65455,3.32E-2,{"$f":"VLOOKUP(G3,$J$7:$K$11,2)","v":"C"},{"$f":"getformula(H3)","v":"<--  =VLOOKUP(G3,$J$7:$K$11,2)"}]
["AXP American Express",{"$f":"LEFT(A4,SEARCH(\" \",A4)-1)","v":"AXP"},101.24,-0.4,-3.9354584809130266E-3,269347,1.66E-2,{"$f":"VLOOKUP(G4,$J$7:$K$11,2)","v":"C"},null,null,null,null,"Lookup Table (Range Shaded Tan)"]
["AAPL Apple","AAPL",179.3,0.33,1.843884449907806E-3,1652676,5.8499999999999996E-2,"B"]
["BA Boeing","BA",369.1,5.62,1.5461648508858809E-2,159409,0.25030000000000002,"A",null,"Score","Rating"]
["CAT Caterpillar","CAT",164.02,0.33,2.0160058647443338E-3,147951,3.8300000000000001E-2,"C",null,-1,"F"]
["CVX Chevron","CVX",115.82,1.22,1.0645724258289704E-2,292028,-7.7499999999999999E-2,"F",null,-0.05,"D"]
["CSCO Cisco","CSCO",45.02,-0.34,-7.4955908289241618E-3,1215162,0.17280000000000001,"A",null,0,"C"]
["KO Coca-Cola","KO",44.09,0.06,1.3627072450601862E-3,297399,-4.0800000000000003E-2,"D",null,0.05,"B"]
["DIS Disney","DIS",105.34,-4.47,-4.0706675166196152E-2,591058,-1.9099999999999999E-2,"D",null,0.1,"A"]
["DWDP DowDuPont Inc","DWDP",73.209999999999994,-0.85,-1.1477180664326224E-2,197709,2.5099999999999997E-2,"C"]
["XOM Exxon Mobil","XOM",79.150000000000006,0.31,3.9320142059868085E-3,642437,-5.6099999999999997E-2,"F",null,"The VLOOKUP function finds the largest value"]
["GE General Electric","GE",14.76,0.11,7.5085324232081908E-3,2501291,-0.15559999999999999,"F",null,"in the first column of the Lookup Table that is"]
["GS Goldman Sachs","GS",272.75,1.49,5.4928850549288508E-3,114852,7.0599999999999996E-2,"B",null,"less than or equal to the lookup_value."]
["HD Home Depot","HD",187.39,-1.07,-5.6775973681417813E-3,165918,-1.29E-2,"D"]
["IBM IBM","IBM",157.88999999999999,-0.69,-4.3511161558834662E-3,154886,2.5399999999999999E-2,"C"]
["INTC Intel","INTC",50.16,1.05,2.1380574221136227E-2,1772997,8.3000000000000004E-2,"B"]
["JNJ Johnson & Johnson","JNJ",133.06,0.99,7.4960248353146061E-3,192328,-4.9200000000000001E-2,"D"]
["JPM JPMorgan Chase","JPM",119.14,0.37,3.1152647975077881E-3,783776,0.1108,"A"]
["MCD McDonald's","MCD",161.97,-1.61,-9.842279007213595E-3,192099,-5.7299999999999997E-2,"F"]
["MRK Merck","MRK",55.82,-0.24,-4.2811273635390652E-3,233498,-1.0699999999999999E-2,"D"]
["MSFT Microsoft","MSFT",95.17,-0.25,-2.6199958080067071E-3,1426263,0.1108,"A"]
["NKE Nike","NKE",68.45,-1.2,-1.7229002153625265E-2,312994,9.35E-2,"B"]
["PFE Pfizer","PFE",37.159999999999997,7.0000000000000007E-2,1.8873011593421411E-3,705383,2.29E-2,"C"]
["PG Procter & Gamble","PG",81.36,-0.27,-3.3076074972436609E-3,370021,-0.1169,"F"]
["TRV Travelers Companies Inc","TRV",142.32,-0.26,-1.8235376630663491E-3,45597,4.5700000000000005E-2,"C"]
["UTX United Technologies","UTX",136.24,0.77,5.6839152579906994E-3,135272,6.2699999999999992E-2,"B"]
["UNH UnitedHealth","UNH",235.81,1.75,7.4767153721268052E-3,95045,6.8699999999999997E-2,"B"]
["VZ Verizon","VZ",48.73,-0.36,-7.3334691383173762E-3,585651,-8.0100000000000005E-2,"F"]
["V Visa","V",124.84,0.25,2.006581587607352E-3,213408,9.2899999999999996E-2,"B"]
["WMT Wal-Mart","WMT",92.63,-0.49,-5.2620274914089351E-3,496769,-6.3500000000000001E-2,"F"]