Note: In order to use the spreadsheet examples, you need to download Business Functions
|SeekList (InputRangePoly, OutputMatrixPoly, InputPoly)|
|Lookup a list and return a one-D list of items from a 2D matrix|
|The function does a plain seek and then, using the matrix of input data, prepares a 1 one dimensional list that is returned. With a normal lookup, you can only return a single value. With SeekList, you can return a list of values ie part of a whole colu|
You give it one InputPoly to look up, a range InputRangePoly to look within, and an OutputMatrixPoly to choose the correct row or column of data. The function works out whether to look across or down OutputMatrixPoly by looking at the orientation of InputRangePoly. The resultant 1D range is equally valid whether the range in which the array formula is is a row or a column.