vimsheet.formula.functions.lookup_funcs

Lookup and reference built-in functions.

vimsheet.formula.functions.lookup_funcs.fn_vlookup(val, range_val, col, approx=True)[source]
Parameters:
Return type:

Any

vimsheet.formula.functions.lookup_funcs.fn_hlookup(val, range_val, row_num, approx=True)[source]
Parameters:
Return type:

Any

vimsheet.formula.functions.lookup_funcs.fn_index(range_val, row_num, col_num=1)[source]
Parameters:

  • range_val (Any)

  • row_num (Any)

  • col_num (Any)

Return type:

Any

vimsheet.formula.functions.lookup_funcs.fn_match(val, range_val, match_type=1)[source]
Parameters:
Return type:

Any

vimsheet.formula.functions.lookup_funcs.fn_xlookup(val, lookup, ret, miss='#N/A')[source]
Parameters:
Return type:

Any

vimsheet.formula.functions.lookup_funcs.fn_choose(idx, *vals)[source]
Parameters:
Return type:

Any

vimsheet.formula.functions.lookup_funcs.fn_row(cell=None)[source]
Parameters:

cell (Any)

Return type:

Any

vimsheet.formula.functions.lookup_funcs.fn_col(cell=None)[source]
Parameters:

cell (Any)

Return type:

Any

vimsheet.formula.functions.lookup_funcs.fn_rows(range_val)[source]
Parameters:

range_val (Any)

Return type:

Any

vimsheet.formula.functions.lookup_funcs.fn_cols(range_val)[source]
Parameters:

range_val (Any)

Return type:

Any

vimsheet.formula.functions.lookup_funcs.fn_offset(ref, rows, cols, h=1, w=1)[source]
Parameters:
Return type:

Any

vimsheet.formula.functions.lookup_funcs.fn_indirect(addr)[source]
Parameters:

addr (Any)

Return type:

Any