A lookup function with a twist
2004-11-25 Functions 0 123
If you look up numbers/text from lists/databases that contains several duplicate values, you will have use for this function. If the value you are looking for occurs more than once, the function displays a dialogbox that lets you select which value you want the function to return.
The example will only work in Excel97 or later because of the use of a UserForm, but can easily be converted to Excel5/95.
Click here to download this file.
Updated: 2004-11-26 Requires: XL97 File size: 12 kB