Thank you, Doug.
On Feb 25, 2016, at 2:06, DougStaubach <firstname.lastname@example.org> wrote
New version of VLookup released
created by DougStaubach in Discussions - View the full discussion
I just wanted to let the FileMaker community know that I have released a new version of VLookup. (New version is v1.2)
In addition to the new version of VLookup I announced last week, I have also created a variation called "VLookupClassic".
This version works EXACTLY the same as it does in Excel and OpenOffice:Calc. (Non-case-sensitive, allows for close matches or exact matches, only returns a single value, or "#N/A" if not match was found).
Syntax for this new variation is: VLookupClassic ( LookupValue ; SearchTableAndFieldName ; ReturnFieldName ; RangeLookup )
Free source code is here => http://www.briandunning.com/cf/1862