Note: In order to use the spreadsheet examples, you need to download Business Functions
|Seek (InputRangePoly, OutputRangePoly, InputPoly_s, [DefaultPoly])|
|Seek a item (number, date or text) in a list of numbers and look up a corresponding item in another list|
|Does a lookup based on getting an exact match. You give it one or more InputPoly_s to look up, a range InputRangePoly to look within, and an OutputRangePoly to choose the correct answer.|
Its a really good idea to have a default if the Seek fails, because if you dont Seek will through an error. Your default could simply say NotFound, or perhaps zero.
TemplatesThis function features in the following downloadable spreadsheet template(s):