Normally a column used in a tableindex has to be a scalar column. However, if a single column is used that column can contain arrays. In such a case the rownrs function finds the rows where a value in its array matches the given search value. If all key values in the index are unique, the function rownr can be used as well. It returns a single row number instead of a vector.