:: Reference:: Range Lookup family:: Seek
[Categories][Families][Data Types][Variables][Topics]
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
Pro
Tip

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.

Example
Seek.xls  
Templates
This function features in the following downloadable spreadsheet template(s):
max_loan_mortgage.xls  finance_lease.xls  goalseekdemo.xls  

Any comments on this documentation? Send us your suggestions below.

Your Email Address (required)
Subject
Message
See Also

SeekNum

230