{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["XLOOKUP_VLOOKUP_Example"],"not_rendered":{"macros":1},"read":"whole","date_system":"1900"}

{"sheet":"XLOOKUP_VLOOKUP_Example","index":0,"n_rows":14,"n_cols":3,"rows_kept":14}
[]
[null,"XLOOKUP to VLOOKUP with an Excel Formula"]
[]
[null,"Select Person","A"]
[null,"Original XLOOKUP formula:",{"$f":"_xlfn.XLOOKUP(C4,B8:B10,C8:C10)","v":25}]
[]
[null,"Person","Age"]
[null,"A",25]
[null,"B",37]
[null,"C",36]
[]
[]
[]
[null,"Converted to VLOOKUP:",{"$f":"\"=VLOOKUP(\"&MID(_xlfn.FORMULATEXT(C5),FIND(\"(\",_xlfn.FORMULATEXT(C5))+1,FIND(\",\",_xlfn.FORMULATEXT(C5))-FIND(\"(\",_xlfn.FORMULATEXT(C5))-1)&\",\"&MID(_xlfn.FORMULATEXT(C5),FIND(\",\",_xlfn.FORMULATEXT(C5))+1,FIND(\":\",_xlfn.FORMULATEXT(C5))-FIND(\",\",_xlfn.FORMULATEXT(C5))-1)&\":\"&MID(_xlfn.FORMULATEXT(C5),MATCH(2,1/(MID(_xlfn.FORMULATEXT(C5),_xlfn.SEQUENCE(LEN(_xlfn.FORMULATEXT(C5))),1)=\":\"))+1,LEN(_xlfn.FORMULATEXT(C5))-MATCH(2,1/(MID(_xlfn.FORMULATEXT(C5),_xlfn.SEQUENCE(LEN(_xlfn.FORMULATEXT(C5))),1)=\":\"))-1)&\",\"&COLUMN(INDIRECT(MID(_xlfn.FORMULATEXT(C5),MATCH(2,1/(MID(_xlfn.FORMULATEXT(C5),_xlfn.SEQUENCE(LEN(_xlfn.FORMULATEXT(C5))),1)=\":\"))+1,LEN(_xlfn.FORMULATEXT(C5))-MATCH(2,1/(MID(_xlfn.FORMULATEXT(C5),_xlfn.SEQUENCE(LEN(_xlfn.FORMULATEXT(C5))),1)=\":\"))-1)&\"1\"))-COLUMN(INDIRECT(MID(_xlfn.FORMULATEXT(C5),FIND(\",\",_xlfn.FORMULATEXT(C5))+1,FIND(\":\",_xlfn.FORMULATEXT(C5))-FIND(\",\",_xlfn.FORMULATEXT(C5))-1)&\"1\"))+1&\",FALSE)\"","v":"=VLOOKUP(C4,B8:C10,2,FALSE)"}]