Currently the aggregation functions only work towards list data type. This disallows to fully replace VLOOKUP function in Excel. Please add at least some additional functionality: for example to search for FIRSTNONBLANK using text data type. That would allow to more easily deal with data without need to maintain excessive lists.
