His version of the function is case-sensitive, and does not allow 'nearby' matches, but it can handle multiple matching values, and it can return multiple fields. Works similar to the Excel VLookup function (but with some nice optional features): Searches in a specific field for a matching lookup value, and returns the value from a different field in the same record. Function definition: (Copy & paste into FileMaker's Edit Custom Function window) /* Version 1.5 - Created by Doug Staubach 2014-Feb-03, Revised 2022-Jun-30.
0 Comments
Leave a Reply. |