11.5.8. look¶

Python equivalents of lookup and reference Excel functions.

Functions

`args_parser_hlookup`
`args_parser_lookup_array`
`args_parser_match_array`
`args_parser_typed_array`
`args_parser_xlookup_array`
`args_parser_xmatch_array`
`input_parser_xlookup`
`input_parser_xmatch`
`map_multiindex_take_last_if_tuple`	For each label in a (Multi)Index, if that label is a tuple, replace it with its second element.
`return_trimrange_func`
`return_unique_func`
`to_python`
`xaddress`
`xareas`
`xchoosecols`
`xcolumn`
`xcolumns`
`xdrop`
`xexpand`
`xfilter`
`xgroupby`
`xhstack`
`xindex`
`xlookup`
`xmatch`
`xrow`
`xsingle`
`xsort`
`xsortby`
`xtake`
`xtocol`
`xtranspose`
`xtrimrange`
`xunique`
`xvstack`
`xwrapcols`
`xxlookup`
`xxmatch`

formulas