Link to good lookup examples
Link to good lookup examples
(OP)
dear all,
Can anyone advice on a site with decent v/hookup examples. illustrations.
Can anyone advice on a site with decent v/hookup examples. illustrations.
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS Come Join Us!Are you an
Engineering professional? Join Eng-Tips Forums!
*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail. Posting GuidelinesJobs |
Link to good lookup examples
|
RE: Link to good lookup examples
The lookup functions are "shorthand" for the Match and Offset functions. Without going into much detail, I must tell you from my experience that it is much better to understand Match and Offset first. You can do a array lookup by using Index and Match, instead of Lookup and Match. I have a couple of examples, or you can do a search in this forum for examples.
Keep in mind the default lookup match type is to pick the lower value in a row or column axis. The row and column axes, in that case, need to arranged in ascending order. For most of my work, exact matches are required, so I almost use the optional eact match option, which does not require that the values be aranged in any particular order.